# linuxdeploy中需要为用户添加特权 usermod -a -G aid_inet,aid_net_raw mysql usermod -a -G aid_inet,aid_net_raw root
1 2
#mysqld service mysql start
允许所有主机登录
1 2 3 4 5
USE mysql; # 改表法 UPDATE user SET host='%' WHERE user='root'; # 授权法 # GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
# 修改配置文件 [mysqld] # user=mysql # validate_password.policy=LOW default_authentication_plugin=mysql_native_password # ALTER USER 'root'@'可访问root的主机' IDENTIFIED WITH mysql_native_password BY 'root的密码'; # 设置密码 ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY ''; flush privileges;