[root@root~]# sudo mkdir -p /var/run/mysqld
[root@root~]# sudo chown mysql:mysql /var/run/mysqld
[root@root~]# mysqld_safe --skip-grant-tables &
[root@root~]# mysql -u root
mysql> UPDATE mysql.user SET authentication_string=PASSWORD('NEW-PASSWORD'), plugin='mysql_native_password' WHERE User='root' ;
mysql> flush privileges;
mysql> exit;
LINUX上mysql重置密码
最新推荐文章于 2023-06-06 11:28:37 发布