1.下載安裝包
2.解壓(當(dāng)前目錄 /home )
# 解壓
tar -Jxvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz
# 重命名
mv mysql-8.0.13-linux-glibc2.12-x86_64 mysql
3.創(chuàng)建用戶組
# 創(chuàng)建組
groupadd mysql
# 創(chuàng)建用戶
useradd -g mysql mysql
4.設(shè)置目錄權(quán)限
chown -R mysql.mysql /home/mysql
5.創(chuàng)建data log目錄
cd /home/mysql
# 創(chuàng)建目錄
mkdir data log
# 創(chuàng)建mysql.pid
touch mysql.pid
# 創(chuàng)建mysql.log
touch log/mysql.log
# 設(shè)置權(quán)限
chown -R mysql /home/mysql/mysql.pid
chgrp -R mysql /home/mysql/mysql.pid
6.配置 my.cnf 文件
vim /etc/my.cnf
----------------------------------
[mysqld]
basedir=/home/mysql
datadir=/home/mysql/data
port=3306
[mysql_safe]
log-error=/home/mysql/logs/mysql.log
pid-file=/home/mysql/mysql.pid
7.初始化mysql
./mysqld --initialize --user=mysql --basedir=/home/mysql/ --datadir=/home/mysql/data
保存初始化密碼
Snipaste_2020-07-22_11-05-25.png
8.設(shè)置開機(jī)啟動(dòng)
# 進(jìn)入support-files目錄
cd /home/mysql/support-files/
# 拷貝
cp mysql.server /etc/init.d/mysql
# 設(shè)置權(quán)限
chmod +x /etc/init.d/mysql
# 設(shè)置開機(jī)啟動(dòng)
chkconfig --add mysql
9.創(chuàng)建軟鏈接
ln -s /home/mysql/bin/mysql /usr/bin
10.啟動(dòng)mysql服務(wù)
service mysql start
Snipaste_2020-07-22_11-12-30.png
11.登錄mysql
mysql -u root -p
輸入上面保存的密碼
Snipaste_2020-07-22_11-13-12.png
12.修改密碼
ALTER user 'root'@'localhost' IDENTIFIED BY 'root';
Snipaste_2020-07-22_11-14-39.png
13.配置遠(yuǎn)程登錄
# 使用mysql數(shù)據(jù)庫(kù)
use mysql;
# 修改root允許遠(yuǎn)程訪問
update user set host='%' where user='root';
# 允許遠(yuǎn)程登錄
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
GRANT ALL ON *.* TO 'root'@'%';
# 刷新
flush privileges;
使用navicat測(cè)試鏈接
Snipaste_2020-07-22_11-25-10.png
mysql安裝成功
如果覺得還不錯(cuò)，點(diǎn)個(gè)贊唄 ！O(∩_∩)O
