安裝
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
mkdir -p /var/mysql/data
mkdir -p /var/mysql/logs
touch /var/mysql/logs/error.log
chown -R mysql:mysql /var/mysql/data
chown -R mysql:mysql /var/mysql/logs
chmod -R 750 /var/mysql/data
chmod -R 750 /var/mysql/logs
cd /usr/local/src
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
tar -xzvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.20-linux-glibc2.12-x86_64 /usr/local/mysql
cd /usr/local/mysql
# 修改配置文件
vi /usr/local/mysql/etc/my.cnf
bin/mysqld --initialize --user=mysql
bin/mysql_ssl_rsa_setup
bin/mysqld_safe --user=mysql &
驗(yàn)證
[root@VM-4-6-centos mysql]# netstat -alnp | grep mysql
tcp 0 0 0.0.0.0:36306 0.0.0.0:* LISTEN 94844/mysqld
tcp 1 0 127.0.0.1:43248 127.0.0.1:36306 CLOSE_WAIT 45721/./bin/mysql
unix 2 [ ACC ] STREAM LISTENING 442984 94844/mysqld /tmp/mysql.sock
unix 2 [ ] STREAM CONNECTED 442969 94844/mysqld
unix 2 [ ] STREAM CONNECTED 239009 45721/./bin/mysql
初始化密碼查看
[root@VM-4-6-centos mysql]# grep password /var/mysql/logs/error.log
2021-12-14T15:24:11.796964Z 1 [Note] A temporary password is generated for root@localhost: S1iqa89UIm&P
登錄
# 登錄
./bin/mysql -h 127.0.0.1 -P 36306 -u root -p
# 修改初始密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY 'S1iqa89UIm&P';
創(chuàng)建子用戶
# 創(chuàng)建用戶
use mysql;
create user 'dev'@'%' identified by 'dev_#29@f18fgw3';
# 授權(quán)
grant all privileges on dev to 'dev'@'%' identified by 'dev_#29@f18fgw3';
# 修改密碼
update user set authentication_string = password('dev_#29@f18fgw3') where user = 'dev' limit 1;
# 允許外網(wǎng)訪問(wèn)
update user set host = "%" where `user` = "dev";
# 刷新權(quán)限
flush privileges;
配置文件修改 /usr/local/mysql/etc/my.cnf
[mysqld]
#mysql啟動(dòng)時(shí)使用的用戶
user = mysql
#默認(rèn)連接端口
port = 36306
#為MySQL客戶端程序和服務(wù)器之間的本地通訊指定一個(gè)套接字文件
# socket = /data/mysql/data/mysql.sock
#數(shù)據(jù)庫(kù)服務(wù)器id，這個(gè)id用來(lái)在主從服務(wù)器中標(biāo)記唯一mysql服務(wù)器
server-id = 1
#端口綁定的ip地址，0.0.0.0表示允許所有遠(yuǎn)程訪問(wèn)，127.0.0.1表示只能本機(jī)訪問(wèn)，默認(rèn)值為*
bind-address = 0.0.0.0
#默認(rèn)名為 主機(jī)名.pid,在數(shù)據(jù)庫(kù)/mysql/data/主機(jī)名.pid,記錄mysql運(yùn)行的process id
#如果存在，再次start時(shí)會(huì)報(bào)已經(jīng)啟動(dòng)
# pid-file = /data/mysql/data/mysql.pid
#安裝目錄
basedir = /usr/local/mysql
#數(shù)據(jù)庫(kù)存放目錄
datadir = /data/mysql/data/
##錯(cuò)誤日志：記錄啟動(dòng)，運(yùn)行，停止mysql時(shí)出現(xiàn)的信息
log-error = /data/mysql/logs/error.log
