centos7 & mysql

標籤：

首先centos7很坑爹。

其次，在centos7上安裝mysql更坑爹。

 

特此記錄一次坑爹曆程後的唯一出路。

安裝mysql

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpmsudo rpm -ivh mysql-community-release-el7-5.noarch.rpmsudo yum install mysql-server

配置

預設的/etc/my.cnf基本啥都沒，參考版本：http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

最小版本：

# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Recommended in standard MySQL setupsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESport=3306collation-server = utf8_unicode_ciinit-connect=‘SET NAMES utf8‘character-set-server = utf8default-storage-engine=InnoDB#default-table-type=InnoDB[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

建立mysql使用者略

 

安裝預設資料庫！

mysql_install_db --datadir=/var/lib/mysql

 

啟動服務

mysqld_safe

用service mysqld restart只會掉進很深很深的坑，此處省略一萬字。

 

轉載請註明本文來源：http://www.cnblogs.com/Tommy-Yu/p/5501861.html

謝謝！

centos7 & mysql