mariadb ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

将root用户的host改成%后，本地服务器登录不上（ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)），navicat可以连接。

先将密码登录屏蔽，再创建一个root用户，host为localhost

创建新用户报错

 ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

修改 my.cnf

添加：skip-grant-tables

 

 屏蔽密码登录

>mysql -uroot  -p

> use mysql;

>create user 'root'@'localhost';

 ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

报错，输入命令刷新即可

>flush privileges ;

>create user 'root'@'localhost';

>grant all privileges on *.* to 'root'@'localhost' identified by '123456' with grant option; 

>flush privileges ;

 

 

到此，root有两个host，%号代表所有ip了，但是mariadb能本地登录，只能再加一个，为啥，有知道的么

 

 把my.cnf的

 skip-grant-tables删除行，或者屏蔽

重启mariadb，再登录就可以了