- 设置root密码
-
- “mariabd”是新密码
- [root@master /]# mysqladmin -u root password mariadb
- [root@master /]# mysql -u root -p
- Enter password:
- Welcome to the MariaDB monitor. Commands end with ; or \g.
- Your MariaDB connection id is 6
- Server version: 10.0.19-MariaDB MariaDB Server
-
- Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
-
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- MariaDB [(none)]> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | performance_schema |
- | test |
- +--------------------+
- 4 rows in set (0.00 sec)
- MariaDB [(none)]> use mysql;
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
-
- Database changed
- MariaDB [mysql]> show tables;
- +---------------------------+
- | Tables_in_mysql |
- +---------------------------+
- | column_stats |
- | columns_priv |
- | db |
- | event |
- 远程登陆设置
-
- 以通配符%的内容增加主机/IP地址,也可以直接增加某个特定IP地址
- [root@master network-scripts]# mysql -u root -p
- Enter password:
- MariaDB [(none)]> use mysql;
- MariaDB [mysql]> select host,user from user;
- +---------------------+------+
- | host | user |
- +---------------------+------+
- | 127.0.0.1 | root |
- | localhost | |
- | localhost | root |
- | master.cloudera.com | |
- | master.cloudera.com | root |
- +---------------------+------+
- 5 rows in set (0.00 sec)
-
- MariaDB [mysql]> update user set host='%' where user='root' and host='localhost';
- MariaDB [mysql]> select host,user from user;
- +---------------------+------+
- | host | user |
- +---------------------+------+
- | % | root |
- | 127.0.0.1 | root |
- | localhost | |
- | master.cloudera.com | |
- | master.cloudera.com | root |
- +---------------------+------+
- 5 rows in set (0.00 sec)
-
- MariaDB [mysql]> flush privileges;
- Query OK, 0 rows affected (0.00 sec)
- HeidiSQL客户端登陆
-
- 网络类型:MySQL
- 主机名/IP:
- 用户名:root
- 密码:mariadb
- 端口:3306
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29070860/viewspace-1701843/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29070860/viewspace-1701843/