1698无法登录mysql服务器,Mysql ERROR 1698 (28000) 解决

一，问题描述：

新装了mysql-server-5.7,

问题一，普通用户不能进mysql：

~$ mysql -u root -p

Enter password:

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

问题二，su root ，直接用root权限登录就不用密码：

~&su root

~$ mysql

Success!

二，解决步骤：

停止mysql服务

~$ sudo service mysql stop

以安全模式启动MySQL

~$ sudo mysqld_safe --skip-grant-tables &

MySQL启动之后就可以不用密码登陆了

~$ mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connectionid is 2Server version:5.7.10 MySQL Community Server (GPL)

查看一下user表，错误的起因就是在这里， root的plugin被修改成了auth_socket，用密码登陆的plugin应该是mysql_native_password。

mysql> select user, plugin from mysql.user;+-----------+-----------------------+

| user | plugin |

+-----------+-----------------------+

| root | auth_socket |

| mysql.sys | mysql_native_password |

| dev | mysql_native_password |

+-----------+-----------------------+

3 rows in set (0.01 sec)

mysql> update mysql.user set authentication_string=PASSWORD('newPwd'), plugin='mysql_native_password' where user='root';

Query OK,1 row affected, 1 warning (0.00sec)

Rows matched:1 Changed: 1 Warnings: 1mysql> flush privileges;

Query OK,0 rows affected (0.00 sec)

重启服务，问题就解决了

~$ sudoservice mysql stop

...* MySQL Community Server 5.7.10is stopped~$ sudoservice mysql start

..* MySQL Community Server 5.7.10is started~$ mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connectionid is 2Server version:5.7.10 MySQL Community Server (GPL)

作者： qq_34771403

链接： https://blog.csdn.net/qq_34771403/article/details/73927962?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522160657843519195271624560%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=160657843519195271624560&biz_i

著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。

到此这篇关于“Mysql ERROR 1698 (28000) 解决”的文章就介绍到这了,更多文章或继续浏览下面的相关文章，希望大家以后多多支持Go语言编程网！

相关文章：