![]()
![]()
Question:

ufo@UPC:~$ mysql -u root -p root;
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
---------------------------------------------------------------------------------------------------------------------------------
Step 1:login
line A:
sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf
add comment [ skip-grant-tables ]
[mysqld]
user = mysql
bind-address = 127.0.0.1
mysqlx-bind-address = 127.0.0.1
skip-grant-tables
service mysql restart;
$ mysql -uroot -p;
OR
line B:
$ sudo mysql -uroot -proot;
The garget :

step 2:check
use mysql;
flush privileges;
select user,plugin from user;

step 3:action
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
flush privileges;

select user,plugin from user;

The results:

---------------------------------------------------------------------------------------------------------------------------------
If you choice Step1-lineA,you'll...:
sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf
#skip-grant-tables

service mysql restart;
done!
这篇博客详细介绍了如何解决MySQL中'root'用户访问被拒绝的问题,通过编辑配置文件并重启服务,然后在没有权限的情况下登录MySQL,检查用户和插件,最后更新root用户的密码并刷新权限。步骤清晰,适用于遇到MySQL权限问题的用户。
3455

被折叠的 条评论
为什么被折叠?



