在CentOS6.4系統(tǒng)中,安裝MySQL5.6可以按照以下步驟進行:
1. 添加MySQL源: wget -i -c http://dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm yum -y install mysql57-community-release-el6-11.noarch.rpm 2. 安裝MySQL及其依賴包: yum -y install mysql-community-server mysql-community-client mysql-community-devel 3. 啟動MySQL服務: service mysqld start 4. 設置MySQL開機自啟動: chkconfig mysqld on 5. 查看MySQL默認密碼: grep 'temporary password' /var/log/mysqld.log 6. 登錄MySQL使用默認密碼: mysql -u root -p 7. 修改MySQL密碼: ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; 8. 設置MySQL字符集: 在/etc/my.cnf文件中添加以下內(nèi)容: [client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] init_connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_general_ci 9. 重啟MySQL服務: service mysqld restart