Linux MySQL专栏-远程管理

创建远程管理账号

mysql> CREATE   USER    'root'@'%'       identified    BY  "root";
Query OK, 0 rows affected (0.07 sec)

mysql> grant all privileges  on  *.*  to 'root'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select user,host,plugin from mysql.user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| root             | %         | caching_sha2_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session    | localhost | caching_sha2_password |
| mysql.sys        | localhost | caching_sha2_password |
| root             | localhost | caching_sha2_password |
+------------------+-----------+-----------------------+
5 rows in set (0.01 sec)

通过Workbench连接

远程管理选项，容易卡住，耐心等一下就好！

通过mysqlsh连接