系统:Windows 8.1
Mysql版本:Mysql-5.7.9-winx64
安装:http://write.blog.csdn.net/postedit
1.将mysql-5.7.9-winx64.zip文件解压到C盘 C:\Mysql 文件下。
2.环境配置:
1.将my-default.ini文件修改为my.ini并打开添加: basedir = C:\Mysql\mysql-5.7.9-winx64
datadir = C:\Mysql\mysql-5.7.9-winx64\data
3.环境变量设置,创建一个MYSQL的用户变量路径为C:\Mysql\mysql-5.7.9-winx64\bin,再将bin文件所在的全路 径既 C:\Mysql\mysql-5.7.9-winx64\bin入到系统变量Path中。
2.该版本无data文件夹,需要手动初始化:mysqld --initlilalize 【As of MySQL 5.7.6, the Zip Archive no longer includes a data directory. To initialize a MySQL installation by creating the data directory and populating the tables in the mysql system database, initialize MySQLusing
either --initialize or --initialize-insecure. For additional information, see Section 2.10.1.1,“Initializing the Data Directory Using mysqld”.
3.启动:net start mysql
密码:
1. 修改密码:mysql> set password for 用户名@localhost = password('新密码'); 例如:mysql> set password for root@localhost = password('x');
2.查看用户: mysql>select User,Password from mysql.user;(不能执行)