Accessdeniedforuser'root'@&#
程序员文章站
2022-06-07 13:25:17
...
$mysqld --skip-grant-tables $ mysql -u root mysql$mysql UPDATE user SET Password=PASSWORD('my_password') where USER='root';$mysql FLUSH PRIVILEGES; $ /etc/init.d/mysql restart $ mysql -u root -pEnter password: my_password 在执行命令前，kil
$mysqld --skip-grant-tables
$ mysql -u root mysql
$mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root';
$mysql> FLUSH PRIVILEGES;
$ /etc/init.d/mysql restart
$ mysql -u root -p
Enter password: my_password
在执行命令前，kill掉mysql的进程
推荐阅读
-
Mysql错误：Duplicateentry'127'forkey_MySQL
-
解决error 1045: Access denied for user: 'root@lo_MySQL
-
默认维护计划之查看各'资源计划组'、'
-
关于mysql数据库“Incorrectstringvalue:'/xFF/xFE/_MySQL
-
解决Accessdeniedforuser''@'
-
error: 'Can't connect to local MySQL_MySQL
-
wampmysqld: unknown variable 'default-character-_MySQL
-
不能将值NULL插入列'id'，表'weibo.
-
Duplicate entry '97112' for key 1_MySQL
-
error: 'Can't connect to local MySQL_MySQL