1.创建/etc/yum.repos.d/MariaDB.repo文件,这里用到了刚刚发布正式版的10.0
[mariadb]
name=MariaDB
baseurl=/10.0/centos6-amd64/
gpgkey=/RPM-GPG-KEY-MariaDB
gpgcheck=1
2.准备好repo文件后可以使用yum来安装了
#yuminstallMariaDB-serverMariaDB-client
3.我喜欢自定义数据目录和服务端口,所以移除默认的数据目录
#rm-rf/var/lib/mysql
4.创建新的数据目录
#mkdir/var/data/db/mariadb
5.修改配置文件/etc/f.d/mysql-f,重点是[client],其他的可以参考
[client]
port=3307
socket=/var/data/db/mariadb/mysql.sock
[mysql]
no-auto-rehash
[mysqldump]
quick
max_allowed_packet=64M
[myisamchk]
key_buffer_size=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M
[mysqlhotcopy]
interactive-timeout
6.修改配置文件/etc/f.d/f,这里的性能参数来自my-large.ini文件
[mysqld]
port=3307
datadir=/var/data/db/mariadb
socket=/var/data/db/mariadb/mysql.sock
skip-external-locking
key_buffer_size=256M
max_allowed_packet=64M
table_open_cache=256
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=4M
myisam_sort_buffer_size=64M
thread_cache_size=8
query_cache_size=16M
thread_concurrency=8
log-bin=mysql-bin
binlog_format=mixed
server-id=1
7.初始化数据
#mysql_install_db--defaults-file=/etc/f--datadir=/var/data/db/mariadb/--user=mysql
8.启动服务
#servicemysqlstart
9.设置ROOT密码
#mysqladmin-urootpassword"8888888"
10.登陆mysql
#mysql-uroot-p
11.授权root远程登录
#root可从任何IP登陆,注意修改密码:'888888'
mysql>GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY'888888'WITHGRANTOPTION;
#root可从指定IP登陆,注意修改密码:'888888'、IP:'192.168.1.188'
mysql>GRANTALLPRIVILEGESON*.*TO'root'@'192.168.1.188'IDENTIFIEDBY'888888'WITHGRANTOPTION;
mysql>FLUSHRIVILEGES