mysql> mysql -u root -p
输入密码:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";任何主机都可以远程登录到该服务器上访问
mysql> flush privileges;更新权限
root用户连接mysql数据库出错 1045 access denied for user 'root'@'localhost' using password yes
解决方案,sql命令:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
GRANT ALL PRIVILEGES ON *.* TO 'root' @'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;
用show variables like 'datadir',可查看真正的data目录