mysql 远程访问权限

mysql 远程访问权限

用root用户进入mysql

mysq>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; 

mysq> FLUSH PRIVILEGES;