1.给所有ip地址的root账户一个权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
2.别忘了最后写入权限
FLUSH PRIVILEGES;
1.给所有ip地址的root账户一个权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
2.别忘了最后写入权限
FLUSH PRIVILEGES;