原文:http://www.cnblogs.com/shanyou/p/3278692.html
MariaDB登陆:http://blog.itpub.net/29070860/viewspace-1701843/
1、在 /etc/yum.repos.d/
下建立 MariaDB.repo,内容如下:
[azureuser@mono etc]$ cd /etc/yum.repos.d
[azureuser@mono yum.repos.d]$ vi MariaDB.repo
# MariaDB 10.0 CentOS repository list - created 2013-08-23 13:08 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
如果是其他的操作系统,可以在这里找到相关信息。
2、使用YUM安装MariaDB
[azureuser@mono yum.repos.d]$ sudo yum -y install MariaDB-client MariaDB-server MariaDB-devel
3、启动数据库
[azureuser@mono yum.repos.d]$ sudo service mysql start
设置root密码
“mariabd”是新密码
[root@master /]#mysqladmin -u root password mariadb
[root@master /]#mysql -u root -p
show databases;
远程登陆设置
以通配符%的内容增加主机/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 sethost='%' 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)