MySQL5.7没有初始密码解决办法

目录焦作缝山针

1.开启跳过权限验证

vi /etc/my.cnf[mysqld]skip-gr形容春天的诗ant-tables/etc/init.d/mysqld restart

2.重置密码

u抖音上生日句子 mysql;update ur 我的极品小桋t authentication_string=password('123456') where ur='root' and host='localhost';flush privileges;/etc/init.d/mysqld restartvi /etc/my.cnf[mysqld]skip-grant-tables    #delete/etc/init.d/权益部mysqld restartalter ur 'root'@'localhost' identified by '123456';