安裝MySQL · BigOps使用手冊

# **安裝MySQL 8.0(推薦)** #### **一、腳本安裝** ``` wget -O mysql80.sh http://www.bigops.com/bigops-install/mysql80.sh bash mysql80.sh ``` 按安裝提示輸入相關安裝信息。 #### **二、優化配置** 修改/etc/my.cnf里innodb\_buffer\_pool\_size的值，innodb\_buffer\_pool\_size設置為剩余內存的70%到80%。修改完后需要重啟MySQL。注意：如果是分布式安裝，還需要在work機器上安裝mysql client 添加yum安裝源 ``` wget -O /etc/yum.repos.d/mysql80-community.repo http://www.bigops.com/yum.repos.d/mysql80-community.repo ``` 安裝MySQL Client ``` yum -y install mysql-community-client mysql-community-devel mysql-community-libs-compat ``` #### **三、配置數據庫** 取消密碼復雜度，有的小版本有，有的小版本沒這些變量，沒有就忽略。 ``` set global validate_password.policy=0; set global validate_password.mixed_case_count=0; set global validate_password.number_count=0; set global validate_password.special_char_count=0; set global validate_password.length=6; ``` 修改密碼。例如：修改root@localhost密碼，your\_password改成你的密碼。 ``` use mysql; ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_password' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password'; flush privileges; ``` 添加用戶。例如：添加root@127.0.0.1，your\_password改成你的密碼。 ``` create user 'root'@'127.0.0.1' identified by 'your_password'; grant all privileges on *.* to 'root'@'127.0.0.1'; flush privileges; ``` 重啟和查看MySQL運行狀態 ``` systemctl restart mysqld systemctl status mysqld -l ``` # **安裝MySQL 5.7** #### **一、腳本安裝** ``` wget -O mysql57.sh http://www.bigops.com/bigops-install/mysql57.sh bash mysql57.sh ``` 按安裝提示輸入相關安裝信息。剩下幾步和MySQL8操作一樣，步驟略。修改密碼和添加用戶略有不同。修改密碼。例如：修改root@localhost密碼，your\_password改成你的密碼。 ``` use mysql; grant all privileges on *.* to "root"@"localhost" identified with mysql_native_password by "your_password"; flush privileges; ``` 添加用戶。例如：添加root@127.0.0.1用戶，your\_password改成你的密碼。 ``` grant all privileges on *.* to "root"@"127.0.0.1" identified with mysql_native_password by "your_password"; flush privileges; ```