wget  http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-5.6.22-1.linux_glibc2.5.x86_64.rpm-bundle.tar 2）下載完后解壓縮并放到安裝文件夾下：
tar -xf MySQL-5.6.22-1.linux_glibc2.5.x86_64.rpm-bundle.tarmv MySQL-5.6.22-1.linux_glibc2.5.x86_64.rpm-bundle /usr/local/software/mv MySQL-5.6.22-1.linux_glibc2.5.x86_64.rpm-bundle mysql其中里面要使用的是這兩個：MySQL數據庫： MySQL-server-5.6.22-1.linux_glibc2.5.x86_64.rpmMySQL客戶端：MySQL-client-5.6.22-1.linux_glibc2.5.x86_64.rpm 3）安裝環境：
cat /etc/RedHat-release CentOS release 6.4 (Final) 二、MySql安裝1）3）檢查安裝在安裝MySQL之前，先檢查CentOS系統中是否已經安裝了一個MySQL，如果已經安裝先卸載，不然會導致安裝新的MySQL失敗。 
rpm -qa | grep mysql   --查看系統之前是否已安裝MySQL。 mysql-libs-5.1.47-4.el6.i686  顯示結果說明 CentOS6.0系統自帶了一個MySQL，我們需要刪除這個老版本，用root用戶執行下面語句su - 密碼：
rpm -e --nodeps mysql-libs-5.1.47-4.el6.i686  
先切換到"root"用戶下，然后執行刪除語句，刪除之后，我們再次查看，發現已經成功刪除了CentOS6.0自帶的舊MySQL版本。在刪除MySQL的rpm后，還要進行一些掃尾操作，網上有兩種操作。（備注：我在這里兩種都沒有用到，發現系統中并沒有其他殘余的MySQL信息。）第一種善后處理：使用下面命令進行處理。
rm -rf /var/lib/mysql*rm -rf /usr/share/mysql*另一種善后處理：卸載后 /var/lib/mysql 中的  /etc/my.cnf 會重命名為 my.cnf.rpmsave，/var/log/mysqld.log 會重命名為 /var/log/mysqld.log.rpmsave，如果確定沒用后就手工刪除。 2）安裝MySql 服務端
rpm -ivh MySQL-server-5.6.22-1.linux_glibc2.5.x86_64.rpm 
PReparing... ########################################### [100%] 1:MySQL-server ########################################### [100%] warning: user mysql does not exist - using root warning: group mysql does not exist - using root 2014-08-10 22:43:44 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-08-10 22:43:44 23012 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-08-10 22:43:44 23012 [Note] InnoDB: The InnoDB memory heap is disabled 2014-08-10 22:43:44 23012 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-08-10 22:43:44 23012 [Note] InnoDB: Memory barrier is not used 2014-08-10 22:43:44 23012 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-08-10 22:43:44 23012 [Note] InnoDB: Using Linux native AIO 2014-08-10 22:43:44 23012 [Note] InnoDB: Not using CPU crc32 instructions 2014-08-10 22:43:44 23012 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-08-10 22:43:44 23012 [Note] InnoDB: Completed initialization of buffer pool 2014-08-10 22:43:45 23012 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2014-08-10 22:43:45 23012 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2014-08-10 22:43:45 23012 [Note] InnoDB: Database physically writes the file full: wait... 2014-08-10 22:43:45 23012 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2014-08-10 22:43:46 23012 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2014-08-10 22:43:46 23012 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2014-08-10 22:43:46 23012 [Warning] InnoDB: New log files created, LSN=45781 2014-08-10 22:43:46 23012 [Note] InnoDB: Doublewrite buffer not found: creating new 2014-08-10 22:43:46 23012 [Note] InnoDB: Doublewrite buffer created 2014-08-10 22:43:46 23012 [Note] InnoDB: 128 rollback segment(s) are active. 2014-08-10 22:43:46 23012 [Warning] InnoDB: Creating foreign key constraint system tables. 2014-08-10 22:43:47 23012 [Note] InnoDB: Foreign key constraint system tables created 2014-08-10 22:43:47 23012 [Note] InnoDB: Creating tablespace and datafile system tables. 2014-08-10 22:43:47 23012 [Note] InnoDB: Tablespace and datafile system tables created. 2014-08-10 22:43:47 23012 [Note] InnoDB: Waiting for purge to start 2014-08-10 22:43:47 23012 [Note] InnoDB: 5.6.22 started; log sequence number 0 A random root passWord has been set. You will find it in '/root/.mysql_secret'. 2014-08-10 22:43:48 23012 [Note] Binlog end 2014-08-10 22:43:48 23012 [Note] InnoDB: FTS optimize thread exiting. 2014-08-10 22:43:48 23012 [Note] InnoDB: Starting shutdown... 2014-08-10 22:43:50 23012 [Note] InnoDB: Shutdown completed; log sequence number 1625977 2014-08-10 22:43:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-08-10 22:43:50 23039 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-08-10 22:43:50 23039 [Note] InnoDB: The InnoDB memory heap is disabled 2014-08-10 22:43:50 23039 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-08-10 22:43:50 23039 [Note] InnoDB: Memory barrier is not used 2014-08-10 22:43:50 23039 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-08-10 22:43:50 23039 [Note] InnoDB: Using Linux native AIO 2014-08-10 22:43:50 23039 [Note] InnoDB: Not using CPU crc32 instructions 2014-08-10 22:43:50 23039 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-08-10 22:43:50 23039 [Note] InnoDB: Completed initialization of buffer pool 2014-08-10 22:43:50 23039 [Note] InnoDB: Highest supported file format is Barracuda. 2014-08-10 22:43:50 23039 [Note] InnoDB: 128 rollback segment(s) are active. 2014-08-10 22:43:50 23039 [Note] InnoDB: Waiting for purge to start 2014-08-10 22:43:50 23039 [Note] InnoDB: 5.6.22 started; log sequence number 1625977 2014-08-10 22:43:50 23039 [Note] Binlog end 2014-08-10 22:43:50 23039 [Note] InnoDB: FTS optimize thread exiting. 2014-08-10 22:43:50 23039 [Note] InnoDB: Starting shutdown... 2014-08-10 22:43:52 23039 [Note] InnoDB: Shutdown completed; log sequence number 1625987 A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER ! You will find that password in '/root/.mysql_secret'. You must change that password on your first connect, no other statement but 'SET PASSWORD' will be accepted. See the manual for the semantics of the 'password expired' flag. Also, the account for the anonymous user has been removed. In addition, you can run: /usr/bin/mysql_secure_installation which will also give you the option of removing the test database. This is strongly recommended for production servers. See the manual for more instructions. Please report any problems at http://bugs.mysql.com/ The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com New default config file was created as /usr/my.cnf and will be used by default by the server when you start it. You may edit this file to change server settings 3）檢測 MySQL 3306 端口是否安打開。測試是否成功可運行 netstat 看 MySQL 端口是否打開，如打開表示服務已經啟動，安裝成功。MySQL 默認的端口是3306。
[root@hadoop Mysql]# netstat -nat  
Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 0.0.0.0:50070 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:50010 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:50075 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:50020 0.0.0.0:* LISTEN tcp 0 0 192.168.128.129:9000 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:50090 0.0.0.0:* LISTEN tcp 1 0 192.168.128.129:35744 63.130.76.64:80 CLOSE_WAIT tcp 0 0 192.168.128.129:34847 192.168.128.129:9000 ESTABLISHED tcp 0 0 192.168.128.129:35770 192.168.128.129:9000 TIME_WAIT tcp 0 52 192.168.128.129:22 192.168.128.1:1297 ESTABLISHED tcp 0 0 192.168.128.129:50968 61.135.185.247:80 ESTABLISHED tcp 0 0 192.168.128.129:9000 192.168.128.129:34847 ESTABLISHED tcp 0 0 :::34803 :::* LISTEN tcp 0 0 :::22 :::* LISTEN tcp 0 0 ::1:631 :::* LISTEN tcp 0 0 :::8088 :::* LISTEN tcp 0 0 :::13562 :::* LISTEN tcp 0 0 :::8030 :::* LISTEN tcp 0 0 :::8031 :::* LISTEN tcp 0 0 :::8032 :::* LISTEN tcp 0 0 :::8033 :::* LISTEN tcp 0 0 :::8040 :::* LISTEN tcp 0 0 :::8042 :::* LISTEN tcp 0 0 ::ffff:192.168.128.129:8031 ::ffff:192.168.128.12:58051 ESTABLISHED tcp 0 0 ::ffff:192.168.128.12:58051 ::ffff:192.168.128.129:8031 ESTABLISHED  4）啟動MySql 服務
[root@hadoop Mysql]# service mysql start   Starting MySQL.......... SUCCESS!  5） 安裝客戶端
[root@hadoop Mysql]# rpm -ivh MySQL-client-5.6.22-1.linux_glibc2.5.x86_64.rpmPreparing...                ########################################### [100%]1:MySQL-client           ^C########################################### [100%]   安裝完成 MySQL的幾個重要目錄。MySQL安裝完成后不像 SQL Server 默認安裝在一個目錄，它的數據庫文件、配置文件和命令文件分別在不同的目錄，了解這些目錄非常重要，尤其對于Linux的初學者，因為 Linux本身的目錄結構就比較復雜，如果搞不清楚MySQL的安裝目錄那就無從談起深入學習。a、數據庫目錄     /var/lib/mysql/ b、配置文件     /usr/share/mysql（mysql.server命令及配置文件） c、相關命令    /usr/bin(mysqladmin mysqldump等命令) d、啟動腳本   /etc/rc.d/init.d/（啟動腳本文件mysql的目錄） 如：/etc/rc.d/init.d/mysql start/restart/stop/status 6）(可選) 更改 MySQL 目錄。由于MySQL數據庫目錄占用磁盤比較大，而MySQL默認的數據文件存儲目錄為 /"var/lib/mysql"，也可以把要把數據目錄移到 "/" 根目錄下的 "mysql_data" 目錄中（如果做測試用就不用移動了）。 停止 MySql 服務進程：service mysql stop  或者  mysqladmin -u root -p shutdownMySQL默認用戶名為"root"，此處的"root"與Linux的最高權限用戶"root"不是一會兒，而且默認的用戶"root"的密碼為空，所以上圖中讓輸入密碼，直接點擊回車即可。把 "/var/lib/mysql" 整個目錄移到 "/mysql_data"
mv /var/lib/mysql /mysql_data 7）找到my.cnf配置文件如果"/etc/"目錄下沒有my.cnf配置文件，請到 "/usr/share/mysql/" 下找到 my-default.cnf  文件，拷貝其中一個合適的配置文件到 "/etc/" 并改名為 "my.cnf" 中。命令如下：
cp /usr/share/mysql/my-medium.cnf　 /etc/my.cnf  默認編碼修改為UTF-8。用下面命令：
vim /etc /my.cnf
[mysqld] #下添加以下命令#socket = /var/lib/mysql/mysql/mysql.sock#datadir=/mysql_data/mysql   #如果你的數據存儲位置要改變的話需要在這里指定存儲目錄character-set-server=utf8lower_case_table_names=1  #（注意linux下mysql安裝完后是默認：區分表名的大小寫，不區分列名的大小寫；#  lower_case_table_names = 0    0：區分大小寫，1：不區分大小寫）注意：1）最后一行，我在本地安裝的時候沒有添加此設置也可以照樣運行起來，加不加還要看你們自己了。2）如果你修改了數據的存儲位置目錄 ，則可以執行以下命令來修改MySQL啟動腳本 "/etc/rc.d/init.d/mysql"  最后，需要修改MySQL啟動腳本 /etc/rc.d/init.d/mysql，修改 datadir=/mysql_data/mysql。 
vim /etc/rc.d/init.d/mysql 8）重新啟動MySQL服務 
service mysql start 9）修改登錄密碼MySQL默認沒有密碼，安裝完畢增加密碼的重要性是不言而喻的。修改前，直接登錄檢查 MySql 端口是否開啟：[root@Hadoop ~]#
netstat -ntlp  | grep 3306tcp        0      0 :::3306                     :::*                        LISTEN      5052/mysqld   進入mysql：[root@hadoop init.d]#
mysql  root的隨機密碼位于/root/.mysql_secret中，如果已經連接上了 MySql 可以使用下面語句 ：
mysql> use mysql; mysql> UPDATE user SET Password=PASSWORD('root') where USER='root';Query OK, 4 rows affected (0.04 sec)Rows matched: 4  Changed: 4  Warnings: 0修改成功；另外，如果登錄mysql數據庫后執行腳本遭遇 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement,可以使用重新設置一次密碼即可解決問題.
mysql>set password = password('p12#456'); 9)本地使用navicat登錄mysql，如果遇到“Mysql host '192.168.1.1' is not allowed to connect to this mysql server”1。 改表法。可能是你的帳號不允許從遠程登陸，只能在localhost。登錄安裝的那臺電腦，登入mysql后，更改 "mysql" 數據庫里的 "user" 表里的 "host" 項，從"localhost"改稱"%"mysql>use mysql;mysql>update user set host = '%' where user = 'root';mysql>select host, user from user;2. 授權法。例如，你想myuser使用mypassword從任何主機連接到mysql服務器的話。GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;FLUSH   PRIVILEGES;如果你想允許用戶myuser從ip為192.168.1.6的主機連接到mysql服務器，并使用mypassword作為密碼GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;FLUSH   PRIVILEGES;如果你想允許用戶myuser從ip為192.168.1.6的主機連接到mysql服務器的dk數據庫，并使用mypassword作為密碼GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;FLUSH   PRIVILEGES;參考資料：http://www.linuxidc.com/Linux/2015-01/111744.htmhttp://blog.csdn.net/itlqi/article/details/50592510