next up previous contents
Next: 實機操作練習題 Up: 用戶管理 Previous: 建立遠端存取帳號   Contents   DYWANG_HOME

遠端存取測試

  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)
    



De-Yu Wang 2020-04-07