[mysqld]
port = 3306
basedir=D:/Prog/mysql-5.7.26-winx64
datadir=D:/Prog/mysql-5.7.26-winx64/data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
explicit_defaults_for_timestamp=true
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE'
[mysql]
default-character-set=utf8
添加my.ini
系统变量里面新建“MYSQL_HOME”值“E:\software\mysql-5.7.21-winx64”
进入bin目录下面 mysqld --initialize
mysqld -install
net start mysql
skip-grant-tables
net stop mysql
net start mysql
即可直接用mysql -u root -p 进入(此时密码为空);
update mysql.user set authentication_string=password("root") where user="root";
flush privileges;
quit;
将my.ini文件还原(删除skip-grant-tables这一行),
重新启动 mysql
密码过期就修改
mysql -uroot -p
set password = password('123456');
在装有MySQL的机器上登录MySQL mysql -u root -p密码
执行use mysql;
执行update user set host = '%' where user = 'root';这一句执行完可能会报错,不用管它。
执行FLUSH PRIVILEGES;