linux系安裝Mysql8.0

參考:https://www.jb51.net/article/160736.htm

下載下傳安裝包

//切換到local 目錄下
cd /user/local 
//下載下傳安裝包
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz 
//解壓安裝包
tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz 
//重命名
mv mysql-8.0.11-linux-glibc2.12-x86_64 mysql8.0
//進入mysql 目錄建立資料存放目錄 data
cd mysql8.0
mkdir data
//建立mysql 使用者群組
groupadd mysql 
useradd -s /sbin/nologin -g mysql mysql -d /usr/local/mysql8.0/
//更改目錄所有者
chown -R mysql:mysql ./
chmod -R 755 /usr/local/mysql8.0/
           

//初始化MySQL 如果初始化失敗重新初始化 必須清空data目錄
./bin/mysqld --user mysql --basedir /usr/local/mysql8.0 --datadir /usr/local/mysql8.0/data --initialize
           

注意記錄初始密碼

//添加系統服務
cp -a /usr/local/mysql8.0/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
//檢視是否添加
chkconfig--list
           

配置環境變量

vim /etc/profile
//使配置生效
source /etc/profile
           

//建立mysql配置檔案
vim /etc/my.cnf
           

配置内容

[client]
port=3306
[mysqld]
port=3306
user=mysql
basedir=/usr/local/mysql8.0
datadir=/usr/local/mysql8.0/data
transaction_isolation = READ-COMMITTED
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1
           

//啟動mysql
service mysqld start
           

//修改mysql 密碼
mysql -uroot -p
//輸入初始化密碼
use mysql;
//修改密碼
ALTER user 'root'@'localhost' IDENTIFIED BY 'yourpassword';
//退出 檢視密碼是否生效
exit 
           

設定遠端登入

use mysql
update user set host='%' where user='root' limit 1;