mysql-8.0.23修改初始密码
部分内容取自(https://blog.csdn.net/weidong_y/article/details/80493743),进行了新版本对应的修改,在Windows10,Mysql 8.0.23版本可用
bin>net stop mysql
bin>mysqld --console --skip-grant-tables --shared-memory
bin>mysql
mysql>use mysql
mysql>ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
mysql>flush privileges;
mysql>quit
bin>mysqladmin -u root -p shutdown
bin>net start mysql