// 查詢出來已安裝的mariadb
[root@localhost ~]# rpm -qa|grep mariadb
// 卸載mariadb，文件名為上述命令查詢出來的文件
[root@localhost ~]# rpm -e --nodeps 文件名
//刪除etc目錄下的my.cnf
[root@localhost ~]# rm /etc/my.cnf
//執(zhí)行以下命令來創(chuàng)建mysql用戶組
[root@localhost ~]# groupadd mysql
//執(zhí)行以下命令來創(chuàng)建一個用戶名為mysql的用戶并加入mysql用戶組
[root@localhost ~]# useradd -g mysql mysql
// 進入/usr/local/下,解壓安裝包
[root@localhost local]# tar -xvf mysql-5.6.34-linux-glibc2.5-x86_64.tar
// 重命名文件 /usr/local
[root@localhost local]# mv mysql-5.6.34-linux-glibc2.5-x86_64 mysql
// 在 etc 下新建配置文件my.cnf 文件路徑 /usr/local/mysql/support-files
[root@localhost support-files]# cp my-default.cnf /etc/my.cnf
// 編輯my.cnf文件缘厢，參考文件內(nèi)容在最后面
[root@localhost support-files]# vim /etc/my.cnf
// 進入目錄
[root@localhost ~]# cd /usr/local/mysql
//修改當(dāng)前目錄擁有著為mysql用戶
[root@localhost mysql]# chown -R mysql:mysql ./
//創(chuàng)建文件夾 這個目錄在my.cnf有用到
[root@localhost mysql]# mkdir ?/var/lib/mysql/
//給權(quán)限
[root@localhost mysql]#?chown -R mysql:mysql ./
// 安裝數(shù)據(jù)庫
[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
// 修改當(dāng)前data目錄的擁有者為mysql用戶
[root@localhost mysql]# chown -R mysql:mysql data
// 授予my.cnf最大權(quán)限
[root@localhost ~]# chown 777 /etc/my.cnf
// 設(shè)置開機自啟動服務(wù)控制腳本：
// 復(fù)制啟動腳本到資源目錄
[root@localhost mysql]# cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
// 增加mysqld服務(wù)控制腳本執(zhí)行權(quán)限
[root@localhost mysql]# chmod +x /etc/rc.d/init.d/mysqld
// 將mysqld服務(wù)加入到系統(tǒng)服務(wù)
[root@localhost mysql]# chkconfig --add mysqld
// 檢查mysqld服務(wù)是否已經(jīng)生效
[root@localhost mysql]# chkconfig --list mysqld
// 命令輸出類似下面的結(jié)果:
// mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
// 表明mysqld服務(wù)已經(jīng)生效贴硫，在2、3间护、4挖诸、5運行級別隨系統(tǒng)啟動而自動啟動，以后可以使用service命令控制mysql的啟動和停止
//命令為:service mysqld start和service mysqld stop
// 啟動mysqld
[root@localhost mysql]# service mysqld start
// 將mysql的bin目錄加入PATH環(huán)境變量多律，編輯 ~/.bash_profile文件
[root@localhost mysql]# vim ~/.bash_profile
//在文件最后添加如下信息:
export PATH=$PATH:/usr/local/mysql/bin
// 執(zhí)行下面的命令是修改的內(nèi)容立即生效:
[root@localhost mysql]# source ~/.bash_profile
// 以root賬戶登錄mysql,默認是沒有密碼的
[root@localhost mysql]# mysql -uroot -p
// 要輸入密碼的時候直接回車即可狼荞。
// 設(shè)置root賬戶密碼為root（也可以修改成你要的密碼）
mysql>use mysql
//需要遠程連接的話將localhost換成%
mysql>update user set password=password('root') where user='root' and host='localhost';
mysql>flush privileges;
// 中間報錯缺少東西，可嘗試執(zhí)行
yum -y install autoconf
my.cnf文件參考內(nèi)容? ?請仔細核對路徑
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
# 設(shè)置mysql客戶端默認字符集
default-character-set=utf8
socket=/var/lib/mysql/mysql.sock
[mysqld]
skip-name-resolve
#設(shè)置3306端口
port = 3306
socket=/var/lib/mysql/mysql.sock
# 設(shè)置mysql的安裝目錄
basedir=/usr/local/mysql
# 設(shè)置mysql數(shù)據(jù)庫的數(shù)據(jù)的存放目錄
datadir=/usr/local/mysql/data
# 允許最大連接數(shù)
max_connections=200
# 服務(wù)端使用的字符集默認為8比特編碼的latin1字符集
character-set-server=utf8
# 創(chuàng)建新表時將使用的默認存儲引擎
default-storage-engine=INNODB
lower_case_table_name=1
max_allowed_packet=16M
