网上安装教程蛮多的,记录下两点:
新版的mysql在配置完my.ini后要
[mysqld]
# skip-grant-tables
basedir = E:\mysql-5.7.11-winx64\mysql-5.7.11-winx64
datadir = E:\mysql-5.7.11-winx64\mysql-5.7.11-winx64\data
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
mysqld --initialize 先初始化data目录
因为原来的没有。。。
修改密码:
mysql -uroot
use mysql
update mysql.user set authentication_string=password("123456") where user="root" and Host='localhost';
之后登陆会提示密码过期:
mysql> SET PASSWORD = PASSWORD('your_new_password');