1.Access denied for user 'root'@'localhost'
本地命令行可正常连接,但web脚本无法连接,则需要为root设置密码,
use mysql;
//版本较新的mysql没有password字段,取而代之的是authentication_string字段
update mysql.user set authentication_string=password('123456') where user='root' and Host ='localhost';
update user set plugin="mysql_native_password";
flush privileges;
2.修改密码策略
show variables like 'validate_password%'; //查看密码策略
set global <参数>=<数值> //修改密码策略
3.开启远程登陆,此处登陆密码可与本地登陆密码不同
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
FLUSH PRIVILEGES;
4.配置文件位置
/etc/mysql/mysqld.conf.d/mysql.cnf