开放远程登录权限
#mysql -uroot -p
输入密码
mysql>use mysql;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql>flush privileges;
mysql>exit;
password是root账号的密码
开放远程登录权限
#mysql -uroot -p
输入密码
mysql>use mysql;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql>flush privileges;
mysql>exit;
password是root账号的密码