MySQL 出现 Access denied for user 'root'@&am_MySQL
程序员文章站
2022-06-14 10:42:11
...
登录某台服务器的mysql时候总报错:
mysql2/client.rb:58:in `connect': Access denied for user 'root'@'localhost' (using password: YES) (Mysql2::Error)
解决方法:
%20在windows%20下的解决方法也一样的
[sql] view%20plaincopy
- # /etc/init.d/mysqld stop
- # mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
- # mysql -u root mysql
- mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
- mysql> FLUSH PRIVILEGES;
- mysql> quit
- # /etc/init.d/mysqld restart
- # mysql -uroot -p
- Enter password:
- mysql>
上一篇: php codeigniter框架分页类_PHP教程
下一篇: GROUP BY与COUNT用法详解
推荐阅读
-
解决mysql创建数据库后出现:Access denied for user 'root'@'%' to database 'xxx'的问题
-
windows 连接 linux 上的mysql出现Can't connect to; is not allowed to connect;Access denied for user
-
MySQL出现Access denied for user ‘root’@’localhost’ (using password:YES)
-
mysql出现ERROR1698(28000):Access denied for user root@localhost错误解决方法
-
解决error 1045: Access denied for user: 'root@lo_MySQL
-
mysql ERROR 1045 (28000): Access denied for user 'ro
-
MySQL 出现 Access denied for user 'root'@&am_MySQL
-
mysql ERROR 1045 access denied for user 'root
-
error: 'Access denied for user 'root'
-
mysql中Access denied for user 'root'