? ? 在官網(wǎng)下載mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz烈疚，上傳到服務(wù)器吏奸，或者直接在服務(wù)器用wget 直接下載下來荆秦，安裝步驟如下：
1.解壓安裝包
命令：tar zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
2.轉(zhuǎn)移安裝包凹嘲，將安裝包復(fù)制到/usr/local/mysql處
命令：cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql
注意目標(biāo)目錄最后不能添加/
3.添加mysql組和添加mysql的用戶
命令：
groupadd mysql
useradd -r -g mysql mysql
4.跳轉(zhuǎn)到/usr/local/mysql
命令：cd ?/usr/local/mysql/
5.將mysql安裝目錄下的所有文件的擁有者修改為mysql用戶
命令：chown -R mysql:mysql ./
6.安裝mysql
命令：./scripts/mysql_install_db --user=mysql
可能出現(xiàn)的問題：
(1)出現(xiàn)問題A
a.報錯信息：FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:
Data::Dumper
b.導(dǎo)致原因： 沒有安裝perl module(autoconf)
c.解決方案：安裝autoconf
命令：yum installautoconf
(該命令視linux系統(tǒng)而定，在centos下為yum install灌旧，在unbuntu下為apt-get install)
(2)問題2
a.報錯信息：Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
b.導(dǎo)致原因：沒有安裝libaio-devel
c.解決方案：安裝libaio-devel
命令：yum install libaio-devel
(該命令視linux系統(tǒng)而定，在centos下為yum install绰筛，在unbuntu下為apt-get install)
7.將當(dāng)前目錄及其文件全部修改為root用戶
命令：chown -R root:root ./
8.將安裝包下的data目錄的擁有者修改為mysql用戶
命令：chown -R mysql:mysql data
9.添加開機自啟動
命令：cp support-files/mysql.server /etc/init.d/mysql
10.將剛添加的自啟動程序添加可執(zhí)行權(quán)限
命令：chmod +x /etc/init.d/mysql
11.添加mysql服務(wù)
命令：chkconfig --add mysql
12.檢測服務(wù)是否可用
命令：chkconfig --list
若mysql下的3枢泰，4，5均為on為成功，網(wǎng)上說，若不成功可填入：chkconfig --level 345 mysql on
（暫未嘗試過）
13.啟動mysql
命令：service mysql start
可能出現(xiàn)的錯誤：（若出現(xiàn)問題脯爪，需要進入14步驟修改密碼）
(1)問題一
a.問題顯示
Starting MySQL.touch: cannot touch '/var/log/mariadb/mariadb.log': No such file or directory
chmod: cannot access '/var/log/mariadb/mariadb.log': No such file or directory
touch: cannot touch '/var/log/mariadb/mariadb.log': No such file or directory
chown: cannot access '/var/log/mariadb/mariadb.log': No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 129: /var/log/mariadb/mariadb.log: No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 166: /var/log/mariadb/mariadb.log: No such file or directory
touch: cannot touch '/var/log/mariadb/mariadb.log': No such file or directory
chown: cannot access '/var/log/mariadb/mariadb.log': No such file or directory
chmod: cannot access '/var/log/mariadb/mariadb.log': No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 129: /var/log/mariadb/mariadb.log: No such file or directory
The server quit without updating PID file (/var/lib/mysql/i[FAILED]3vu81gmebyu2tZ.pid).
b.產(chǎn)生原因:log目錄沒有創(chuàng)建/var/log/mariadb/
c.解決方案:創(chuàng)建log目錄文件夾
命令：mkdir /var/log/mariadb
14.修改密碼：
命令：./bin/mysqladmin -u root password '這里填寫你的密碼'
可能出現(xiàn)問題：
（1）問題一
a.錯誤信息：
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
b.解決方案
首先幸缕，關(guān)閉mysql服務(wù)
其次，修改配置文件（5.6.33是my.cnf景东，部分為my.conf），在配置文件處的[client]下添加socket=/var/lib/mysql/mysql.sock，如圖所示
最后玻募，重新啟動mysql,
命令：/usr/local/mysql/bin/mysqld_safe& service mysql start
14.無法使用14直接修改密碼的繼續(xù)這一步驟
a.進入剛剛安裝目錄下的bin
命令：cd /usr/local/mysql/bin
b.進入mysql
命令：./mysql -u root -p
密碼為空
c.在mysql控制臺下：
use mysql;
update user set password=password("你的密碼") where user = 'root' and host = 'localhost';
flush privileges;
