[原]CentOS 6.5 上安裝 MySQL 5.6

標籤：

參考文檔: http://dev.mysql.com/doc/refman/5.6/en/linux-installation-yum-repo.html

1. 下載 rpm 檔案:
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

2. 安裝 rpm 檔案
sudo yum localinstall mysql-community-release-el6-5.noarch.rpm

3. 檢查 rpm 是否已經安裝成功:
yum repolist enabled | grep "mysql.*-community.*"

4. 安裝 mysql
sudo yum install mysql-community-server

5. 啟動 mysql
sudo service mysqld start

6. 停止 mysql
sudo service mysqld stop

7. 執行安全設定
mysql_secure_installation

 

8. 遠程登入設定(假設root密碼為mypassword)

mysql -u root -pmypassword)
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;

[原]CentOS 6.5 上安裝 MySQL 5.6