Client 遠端存取

1. Client 要存取遠端的 mysql，必須以 root 權限先安裝 mysql。
   

   [root@dyw219 ~]# yum install mysql
   

2. Client 端以 hosttest 帳號登入遠端 192.168.122.6 的 mysql。
   

   [root@dyw219 ~]# mysql -uhosttest -p123qwe -h 192.168.122.6
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 23
   Server version: 5.5.49 MySQL Community Server (GPL) by Remi
   
   Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
   
   Oracle is a registered trademark of Oracle Corporation and/or its
   affiliates. Other names may be trademarks of their respective
   owners.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
   mysql>
   mysql> exit
   Bye
   

3. Client 端以 root 帳號無法登入遠端 192.168.122.6 的 mysql，因為 server 設定 root 帳號的 host 是 localhost，所以 root 只能在本機存取 mysql 。
   

   [root@dyw219 ~]# mysql -uroot -p123qwe -h 192.168.122.6
   ERROR 1045 (28000): Access denied for user 'root'@'deyu.wang' (using password: YES)