系统是centos的LAMP集成包,mysql改过root密码
mysql -u root -p
输入密码后
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysqld_safe --skip-grant-tables &
进入后查看root的密码无误,google下大部分说是权限问题。
可现在mysql进不去,只能进safe模式,safe模式下用grant all privileges......提示
The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
那现在应该怎么赋予权限?
解决方案:
1、进入数据库:
mysql -u root -p
2、输入数据库密码
******
3、依次执行以下sql:
CREATE USER 'root'@'%' IDENTIFIED BY '你的密码';
GRANT ALL ON *.* TO 'root'@"%;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';
FLUSH PRIVILEGES;
解决方案2:
进入/etc/my.conf
在mysqld下添加skip-grant-tables
重启mysql
systemctl stop mysqld
systemctl start mysqld