yum源安装MariaDB-10.0数据库

1.配置yun源 可以到http://yum.mariadb.org/中找到适合自己的系统的版本
vim /etc/yum.repos.d/MariaDB.repo

[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安装
yum -y install MariaDB-client MariaDB-server

3.启动mysql
service mysql start

4.修改root密码
mysqladmin -u root password '111111'

5.登录数据库
.mysql -u root -p

6.赋予远程访问的权限
GRANT ALL PRIVILEGES ON . TO 'root'@'%'IDENTIFIED BY '111111' WITH GRANT OPTION;

7.根据需要修改配置文件
vim /etc/my.cnf

[mysqld]
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
slow-query-log-file=/var/lib/mysql/slowquery.log
long_query_time=1
log-queries-not-using-indexes
log-bin=mysqlbin-log

转载于:https://blog.51cto.com/zhangxiaoxiong/2128882