Centos 使用YUM安装MariaDB,MySQL

原文：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)