一、下載MYSQL
在官方網(wǎng)站下載MySQL安裝包，下載地址: https://www.mysql.com/downloads/
安裝MYSQL
- 解壓MySQL安裝包
tar -zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local/mysql
- 添加系統(tǒng)用戶和用戶組
groupadd mysql
useradd -r -g mysql mysql
- 創(chuàng)建MySQL數(shù)據(jù)目錄
mkdir /usr/local/mysql/data
- 修改MySQL目錄權(quán)限
chown -R mysql:mysql /usr/local/mysql
- 初始化數(shù)據(jù)庫
cd /usr/local/mysql
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
- 修改MySQL目錄權(quán)限
chown -R root:root ./
chown -R mysql:mysql data
- 添加啟動(dòng)服務(wù)
cp support-files/mysql.server /etc/init.d/mysql
- 修改MySQL配置文件
vim /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
user=mysql
port=3306
character-set-server=utf8
symbolic-links=0
?
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
?
!includedir /etc/my.cnf.d
三、配置MySQL賬號(hào)密碼以及遠(yuǎn)程連接
- 修改my.cnf配置
[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/tmp/mysql.sock
user=mysql
port=3306
character-set-server=utf8
# 跳過密碼驗(yàn)證
skip-grant-tables
symbolic-links=0
?
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
?
!includedir /etc/my.cnf.d
- 重啟MySQL服務(wù)
service mysql restart
- 設(shè)置用戶登陸密碼
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
mysql> FLUSH PRIVILEGES;
- 設(shè)置MySQL遠(yuǎn)程訪問
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
