遠端存取測試

1. 要存取遠端的 mariadb，本地端必須先安裝 mariadb/mysql。

   [root@dyw219 ~]# yum install mysql
   

2. 本地端成功以 hosttest 帳號登入遠端 kvm8.deyu.wang (192.168.122.8) 的 mariadb。

   [root@dyw219 ~]# mysql -h kvm8.deyu.wang -uhosttest -p123qwe
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 36
   Server version: 5.5.5-10.3.11-MariaDB MariaDB Server
   
   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> quit;
   Bye
   

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

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

4. 從 mariadb server (kvm8.deyu.wang) 以 hosttest 帳號也無法登入 mariadb，因為 hosttest 的主機設定為 192.168.122.8。

   [root@kvm8 ~]# mysql -uhosttest -p123qwe
   ERROR 1045 (28000): Access denied for user 'hosttest'@'localhost' (using password: YES)