1. 设置root密码
   
2. 
   
3. “mariabd”是新密码
   
4. [root@master /]# mysqladmin -u root password mariadb
   
5. [root@master /]# mysql -u root -p
   
6. Enter password:
   
7. Welcome to the MariaDB monitor. Commands end with ; or \g.
   
8. Your MariaDB connection id is 6
   
9. Server version: 10.0.19-MariaDB MariaDB Server
   
10.  
    
11. Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
    
12.  
    
13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
14. MariaDB [(none)]> show databases;
    
15. +--------------------+
    
16. | Database |
    
17. +--------------------+
    
18. | information_schema |
    
19. | mysql |
    
20. | performance_schema |
    
21. | test |
    
22. +--------------------+
    
23. 4 rows in set (0.00 sec)
    
24. MariaDB [(none)]> use mysql;
    
25. Reading table information for completion of table and column names
    
26. You can turn off this feature to get a quicker startup with -A
    
27.  
    
28. Database changed
    
29. MariaDB [mysql]> show tables;
    
30. +---------------------------+
    
31. | Tables_in_mysql |
    
32. +---------------------------+
    
33. | column_stats |
    
34. | columns_priv |
    
35. | db |
    
36. | event |
    
37. 远程登陆设置
    
38. 
    
39. 以通配符%的内容增加主机/IP地址，也可以直接增加某个特定IP地址
    
40. [root@master network-scripts]# mysql -u root -p
    
41. Enter password:
    
42. MariaDB [(none)]> use mysql;
    
43. MariaDB [mysql]> select host,user from user;
    
44. +---------------------+------+
    
45. | host | user |
    
46. +---------------------+------+
    
47. | 127.0.0.1 | root |
    
48. | localhost | |
    
49. | localhost | root |
    
50. | master.cloudera.com | |
    
51. | master.cloudera.com | root |
    
52. +---------------------+------+
    
53. 5 rows in set (0.00 sec)
    
54. 
    
55. MariaDB [mysql]> update user set host='%' where user='root' and host='localhost';
    
56. MariaDB [mysql]> select host,user from user;
    
57. +---------------------+------+
    
58. | host | user |
    
59. +---------------------+------+
    
60. | % | root |
    
61. | 127.0.0.1 | root |
    
62. | localhost | |
    
63. | master.cloudera.com | |
    
64. | master.cloudera.com | root |
    
65. +---------------------+------+
    
66. 5 rows in set (0.00 sec)
    
67. 
    
68. MariaDB [mysql]> flush privileges;
    
69. Query OK, 0 rows affected (0.00 sec)
    
70. HeidiSQL客户端登陆
    
71. 
    
72. 网络类型：MySQL
    
73. 主机名/IP：
    
74. 用户名：root
    
75. 密码：mariadb
    
76. 端口：3306