选择mysql
1、mysql>use mysql;
赋予任何主机访问数据的权限
2、mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' by ‘password’ WITH GRANT OPTION;
刷新权限
3、mysql>FLUSH PRIVILEGES;
选择mysql
1、mysql>use mysql;
赋予任何主机访问数据的权限
2、mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' by ‘password’ WITH GRANT OPTION;
刷新权限
3、mysql>FLUSH PRIVILEGES;