忘记mysql数据库密码如何操作
mysql5.6.51找回密码和修改密码
操作一
net stop mysql5
mysqld --skip-grant-tables
操作二
mysql -u root -p
select host,user,password from mysql.user;
操作三(此时已经获得密码)
https://www.cmd5.com/
操作四(修改密码)
update mysql.user set password = ' ';
操作五(修改密码)
net start mysql5
mysql -u root -p
select host,user,password from mysql.user;
set password = password('123456');
mysql8.1.0找回密码与修改密码
操作一
net stop mysql8
mysqld --console --skip-grant-tables --shared-memory
操作二
mysql -u root -p
update mysql.user set authentication_string='' where host='localhost' and user='root';
select host,user,authentication_string from mysql.user;
操作三(设置密码:操作一页面不关闭没办法重设密码)
net start mysql8
mysql -u root -p
set password = '123456';
select host,user,authentication_string from mysql.user;