新初始化后修改部分账号权限遇到操作

MariaDB:10.4.11 具体报错如下 处理办法： mysql>select user,host from user; 根据查询结果修改执行内容，比如 mysql>alter user ‘root’@‘XX.XX.XX.XX’ identified by ‘PASSWORD’;

ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement 如果遇到如上报错，执行刷新权限后在执行如下命令即可 mysql>flush privileges ; mysql>alter user ‘root’@‘XX.XX.XX.XX’ identified by ‘PASSWORD’; mysql>flush privileges ;

异常解决

问题1：如果还有报错’root’@'localhost

create user 'root'@'localhost'; grant all privileges on *.* to 'root'@'localhost' identified by 'PASSWORD' with grant option; flush privileges;

问题解决