CentOS用yum安裝、配置MariaDB

標籤：flush   pack   _for   root密碼   ide   option   write   初始化   etc   

1.建立/etc/yum.repos.d/MariaDB.repo檔案，這裡用到了剛剛發布正式版的10.0[mariadb]name = MariaDBbaseurl = http://yum.mariadb.org/10.0/centos6-amd64/gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDBgpgcheck=12.準備好repo檔案後可以使用yum來安裝了# yum install MariaDB-server MariaDB-client3.我喜歡自訂資料目錄和服務連接埠，所以移除預設的資料目錄# rm -rf /var/lib/mysql4.建立新的資料目錄# mkdir /var/data/db/mariadb5.修改設定檔/etc/my.cnf.d/mysql-clients.cnf，重點是[client]，其他的可以參考[client]port        = 3307socket      = /var/data/db/mariadb/mysql.sock[mysql]no-auto-rehash[mysqldump]quickmax_allowed_packet = 64M[myisamchk]key_buffer_size = 128Msort_buffer_size = 128Mread_buffer = 2Mwrite_buffer = 2M[mysqlhotcopy]interactive-timeout6.修改設定檔/etc/my.cnf.d/server.cnf，這裡的績效參數來自my-large.ini檔案[mysqld]port            = 3307datadir         = /var/data/db/mariadbsocket          = /var/data/db/mariadb/mysql.sockskip-external-lockingkey_buffer_size = 256Mmax_allowed_packet = 64Mtable_open_cache = 256sort_buffer_size = 1Mread_buffer_size = 1Mread_rnd_buffer_size = 4Mmyisam_sort_buffer_size = 64Mthread_cache_size = 8query_cache_size= 16Mthread_concurrency = 8log-bin=mysql-binbinlog_format=mixedserver-id   = 17.初始化資料# mysql_install_db --defaults-file=/etc/my.cnf --datadir=/var/data/db/mariadb/ --user=mysql8.啟動服務# service mysql start9.設定ROOT密碼# mysqladmin -u root password "8888888"10.登陸mysql# mysql -uroot -p11.授權root遠程登入#root可從任何IP登陸，注意修改密碼:‘888888‘ mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘888888‘ WITH GRANT OPTION;#root可從指定IP登陸，注意修改密碼:‘888888‘、IP:‘192.168.1.188‘mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘192.168.1.188‘ IDENTIFIED BY ‘888888‘ WITH GRANT OPTION;mysql>FLUSH RIVILEGES

 

CentOS用yum安裝、配置MariaDB