Mysql授权root用户远程登录

默认情况下Mysql的root用户不支持远程登录，使用以下命令授权   [Charles@localhost ~]$ mysql -uroot -p123 MariaDB [(none)]> use mysql;   MariaDB [mysql]> select Host from user; +-----------+ | Host      | +-----------+ | 127.0.0.1 | | ::1       | | localhost | +-----------+ 3 rows in set (0.00 sec) 现在没有%，所以不能远程登录   MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION; MariaDB [mysql]> FLUSH   PRIVILEGES;   MariaDB [mysql]> select Host from user; +-----------+ | Host      | +-----------+ | %         | | 127.0.0.1 | | ::1       | | localhost | +-----------+ 4 rows in set (0.00 sec)