# mysql -u root -proot
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
之后刷新权限即可。
FLUSH PRIVILEGES
服务器记得打开3306端口。
# mysql -u root -proot
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
之后刷新权限即可。
FLUSH PRIVILEGES
服务器记得打开3306端口。