mysql ERROR 1698

mysql ERROR 1698

这个问题的原因是因为我们安装mysql 时没有设置密码，导致我们无法进入mysql, 一般初次安装会出现这样的问题。

解决方法：

step1:

在命令行输入 sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
进入这个配置文件，之后在 [mysqld] 块中加入skip-grant-tables这句话（意思为跳过认证表），之后按wq保存

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
#lc-messages-dir =/usr/share/mysql
skip-external-locking
skip-grant-tables    //<---在这里添加

或者还可以在命令行输入

sudo mysqld_safe --skip-grant-tables &

step2:

重新启动 service mysql

sudo service mysql restart

step3

(1)进入mysql

mysql -uroot 或直接 mysql

(2) 跳到mysql这个库

mysql> use mysql;

(3)执行修改设置(修改)密码，并调整一下plugin参数

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

step4

将跳过认证表的命令撤销，并重启mysql服务

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
#lc-messages-dir =/usr/share/mysql
skip-external-locking
#skip-grant-tables

sudo service mysql restart

最后就可以用正常登进去了

mysql -uroot -p 123456

如果上述方式有语法错误或一些问题，可能是mysql版本过高可以使用如下方法

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
#lc-messages-dir =/usr/share/mysql
skip-external-locking
skip-grant-tables    //<---在这里添加

mysql

use mysql

update  mysql.user set  `plugin`='mysql_native_password'  WHERE `user`='root' AND `host`='localhost' ;

flush privileges;

alter user 'root'@'localhost' identified by '123456';