centos7mariaDb5.5升级到最新版本

1.创建/etc/yum.repos.d/MariaDB.repo文件，这里用到了刚刚发布正式版的10.0

[mariadb] name = MariaDB

baseurl = /10.0/centos6-amd64/

gpgkey=https:///RPM-GPG-KEY-MariaDB gpgcheck=1

2.关闭并卸载旧版本的mariadb，安装新版本的mariadb。 systemctl stop mariadb

yum remove mariadb-server mariadb mariadb-libs yum clean all

yum install MariaDB-server MariaDB-client

3.自定义数据目录和服务端口，移除默认的数据目录，创建新的数据目录。

rm -rf /var/lib/mysqlmkdir /var/data/db/mariadb

4.修改配置文件/etc/my.cnf.d/mysql-clients.cnf，重点是[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

5.修改配置文件/etc/my.cnf.d/server.cnf，这里的性能参数来自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 6.初始化数据 mysql_install_db

--defaults-file=/etc/my.cnf

--

datadir=/var/data/db/mariadb/ --user=mysql

7.启动服务

systemctl restart mysql 8.设置ROOT密码

mysqladmin -u root password \"8888888\" 9.登陆mysql mysql -uroot -p 10.授权root远程登录

root可从任何IP登陆，注意修改密码:'888888'

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '888888' WITH GRANT OPTION;

mysql>FLUSH RIVILEGES;

root可从指定IP登陆，注意修改密码:'888888'、IP:'192.168.1.188'

mysql>GRANT OPTION;

mysql>FLUSH RIVILEGES;

ALL

PRIVILEGES

ON

*.*

TO

'root'@'192.168.1.188' IDENTIFIED BY '888888' WITH GRANT