1.需要远程服务器同意:
在远程服务器端:
grant all PRIVILEGES on test_db.* to root@'192.168.1.101' identified by '123456';
2.本地登录:
-h 192.168.5.116 -P 3306 -u root -p123456
在远程服务器端:
grant all PRIVILEGES on test_db.* to root@'192.168.1.101' identified by '123456';
-h 192.168.5.116 -P 3306 -u root -p123456