CentOS7離線安裝Mysql8.0.18
查詢出來已安裝的mariadb
rpm -qa|grep mariadb
卸載mariadb，檔案名為上述命令查詢出來的檔案
rpm -e --nodeps 檔案名
上傳安裝包到/opt目錄
解壓安裝包
tar Jxvf mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz
重命名
mv mysql-8.0.18-linux-glibc2.12-x86_64 mysql
mv mysql /usr/local
創建資料目錄
mkdir /usr/local/mysql/data
創建并編輯my.cnf檔案
vim /etc/my.cnf
填入以下內容
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
port=3306
user=mysql
socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=/usr/local/mysql/error.log
pid-file = /usr/local/mysql/mysql.pid
transaction_isolation = READ-COMMITTED
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"
創建組
groupadd mysql
創建用戶
useradd -g mysql mysql
修改目錄權限
- 將 /opt/mysql給予mysql用戶
chown -R mysql:mysql /usr/local/mysql
- 將/opt/mysql權限設定為755
chmod -R 755 /usr/local/mysql
初始化mysql
cd /usr/local/mysql
./bin/mysqld --initialize --user=mysql
嘗試啟動mysql
cd /usr/local/mysql
./support-files/mysql.server start
啟動成功則如下:
將mysql添加為服務
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
設定開機啟動
cd /etc/init.d
chmod 755 /etc/init.d/mysql
chkconfig --add mysql
chkconfig --level 345 mysql on
service mysql restart
配置環境變數
echo 'export MYSQL_HOME=/usr/local/mysql' >> /etc/profile
echo 'export PATH=.:$MYSQL_HOME/bin:$PATH' >> /etc/profile
source /etc/profile
使用默認密碼登錄mysql
在mysql目錄下有一個error.log的檔案,打開可以看到默認密碼
mysql -uroot -p(默認密碼)
在MySQL8中第一次登陸需要重新設定root密碼
ALTER user 'root'@'localhost' IDENTIFIED BY '123456';
開啟遠程訪問
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
GRANT ALL ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;
以上操作完,可以去遠程客戶端登錄訪問
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/155724.html
標籤：其他