ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.6/mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz

tar -xzf mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz

注：安裝目錄需要設置到解壓目錄，否則報以下錯誤

FATAL ERROR: Could not find ./bin/my_PRint_defaultsIf you compiled from source, you need to run 'make install' tocopy the software into the correct location ready for Operation.If you are using a binary release, you must either be at the toplevel of the extracted archive, or pass the --basedir optionpointing to that location.

or

FATAL ERROR: Could not find my-default.cnfIf you compiled from source, you need to run 'make install' tocopy the software into the correct location ready for operation.If you are using a binary release, you must either be at the toplevel of the extracted archive, or pass the --basedir optionpointing to that location.

將解壓的目錄放到/usr/local下改為mysql或添加軟連接

mv mysql-5.6.26-linux-glibc2.5-x86_64 mysql

or

ln -s  /www/mysql-5.6.26-linux-glibc2.5-x86_64 /usr/local/mysql

groupadd mysqluseradd -r -g mysql mysql

修改mysql目錄及子文件屬主和屬組

chown -R mysql:mysql mysql

cd mysqlscripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/var/lib/mysql

安裝過程可能缺少某些文件，一般用yum install -y xxx按需安裝即可.

實現使用service mysqll (start|status|stop)命令操作mysql.

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

錯誤：

[root@localhost mysql]# mysql-bash: mysql: command not found

解決：配置環境變量，把export PATH=$PATH:/usr/local/mysql/bin添加到/etc/profile中，source /etc/profile重新加載環境變量，service mysql start啟動mysql服務。

錯誤：

[root@localhost mysql]# mysqlERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

解決：

mysql --socket=/var/lib/mysql/mysql.sockln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

mysql> select version();+-----------+| version() |+-----------+| 5.6.26 |+-----------+1 row in set (0.00 sec)

錯誤：指定了嚴格模式，為了安全，嚴格模式禁止通過insert 這種形式直接修改mysql庫中的user表進行添加新用戶

1364 - Field 'ssl_cipher' doesn't have a default value

解決：

vim /usr/local/mysql/my.cnf

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES改為sql_mode=NO_ENGINE_SUBSTITUTION