CentOS7 二進制 安裝 mysql8
1:CentOS 7 下,默認安裝的數據庫為 MariaDB,安裝 MySQL 前需要卸載 MariaDB 數據庫。
#檢查系統是否已經安裝mysql,若有,需要先卸載
rpm -qa | grep mariadb
rpm -qa | grep mysql
2:準備mysql8.0的二進制包
#解壓mysql二進制包到/usr/local/下
tar -xvf mysql-8.0.20-linux-glibc2.12-x86_64.tar -C /usr/local/
#修改一下名稱,更加簡介
mv mysql-8.0.20-linux-glibc2.12-x86_64/ mysql8.0
3:創建mysql組
groupadd mysql
4:創建mysql用戶并添加到mysql組
useradd -g mysql mysql (-g, --gid GROUP 新賬戶主組的名稱或 ID)
5:創建data目錄,日志目錄,變更權限
mkdir /usr/local/mysql8.0/data
mkdir /usr/local/mysql8.0/log
chown -R mysql:mysql /usr/local/mysql8.0/
6:創建my.cnf配置文件,如果之前目錄中存在此文件可先刪除
touch /etc/my.cnf
7:編輯配置文件
vi /etc/my.cnf
[mysqld]
port=3306
socket=/usr/local/mysql8.0/data/mysql.sock
basedir=/usr/local/mysql8.0
datadir=/usr/local/mysql8.0/data
log-error=/usr/local/mysql8.0/mysqlerr.log
8:初始化數據庫
/usr/local/mysql8.0/bin/mysqld --defaults-file=/etc/my.cnf --user=mysql --initialize
9:查看密碼
cd /usr/local/mysql8.0/log
cat mysqlerr.log
2021-04-12T05:38:42.072231Z 0 [System] [MY-013169] [Server] /usr/local/mysql8.0/bin/mysqld (mysqld 8.0.20) initializing of server in progress as process 6087
2021-04-12T05:38:42.099905Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-12T05:38:43.645229Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-04-12T05:38:48.520559Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: tWkOGizom2/*
密碼為:tWkOGizom2/*
10:啟動數據庫
/usr/local/mysql8.0/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &
11:登錄數據庫
/usr/local/mysql8.0/bin/mysql -uroot -p
12:修改root用戶密碼
alter user 'root'@'localhost' identified with mysql_native_password by 'root';
13:設置數據庫遠程連接
use mysql;
update user set host='%' where user='root';
重啟mysql服務,即可遠程連接。

浙公網安備 33010602011771號