- 官網(wǎng)下載社區(qū)版，.tar.xz文件（傳送）
- 卸載MariaDB，centos7中使用yum install,默認安裝的是此數(shù)據(jù)庫，此數(shù)據(jù)庫完全兼容mysql。
ps -ef | grep maria*, ps -ef | grep mysql, yum remove xxx
- tar解壓tar.xz文件到你喜歡的目錄
tar -xvf mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz
- 自己在/etc目錄下新建my.cnf，例如：
# MySQL 配置文件，
# 數(shù)據(jù)庫目錄 /home/local/mysql-8.0.19-linux-glibc2.12-x86_64/data
[client]
port=33689
# mysql socket 文件存放地址
socket=/tmp/mysql.sock
# 默認字符集
default-character-set=utf8
[mysqld]
server-id=1
# 端口
port=33689
# 運行用戶
user=mysql
# 最大連接
max_connections=200
socket=/tmp/mysql.sock
# mysql 安裝目錄（解壓后文件的目錄）
basedir=/home/local/mysql-8.0.19-linux-glibc2.12-x86_64
# 數(shù)據(jù)目錄（這里放在我們新建的 /data/mysql 下）
datadir=/home/local/mysql-8.0.19-linux-glibc2.12-x86_64/data
pid-file=/home/local/mysql-8.0.19-linux-glibc2.12-x86_64/data/mysql.pid
init-connect='SET NAMES utf8'
character-set-server=utf8
# 數(shù)據(jù)庫引擎
default-storage-engine=INNODB
log_error=/home/local/mysql-8.0.19-linux-glibc2.12-x86_64/data/mysql-error.log
slow_query_log_file=/home/local/mysql-8.0.19-linux-glibc2.12-x86_64/data/mysql-slow.log
transaction_isolation=READ-COMMITTED
default-authentication-plugin=mysql_native_password
# 跳過驗證密碼
#skip-grant-tables
[mysqldump]
quick
#max_allowed_packet=16M
EOF
- 添加linux添加mysql用戶并授權目錄訪問權限
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql chown -R /home/local/mysql-8.0.19-linux-glibc2.12-x86_64/data
chown -R mysql:mysql /home/local/mysql-8.0.19-linux-glibc2.12-x86_64/data
chown -R mysql:mysql /home/local/mysql-8.0.19-linux-glibc2.12-x86_64
chown -R 755 /home/local/mysql-8.0.19-linux-glibc2.12-x86_64
chown -R 755 /home/local/mysql-8.0.19-linux-glibc2.12-x86_64/data/
- 初始化mysql數(shù)據(jù)庫，期間可能需要你安裝對應的依賴庫
yum install libaio*
./bin/mysqld --initialize --user=mysql
- 找到默認的root密碼并修改
# 先啟動
/support-files/mysql.server start
vi /home/local/mysql-8.0.19-linux-glibc2.12-x86_64/datadata/mysql-error.log
image.png
./bin/mysql -uroot -p
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
./support-files/mysql.server stop
./support-files/mysql.server start
- mysql8默認caching_sha2_password設置是另一個問題
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
