Linux 安裝 Mysql

2022-12-20 18:20:58 來源:51CTO博客

一、下載安裝包

安裝包下載 ??https://downloads.mysql.com/archives/community/??

選擇自己要下載的版本下載

二、上傳到Linux機器進行解壓

tar -zxvf mysql-5.7.39-linux-glibc2.12-x86_64.tar.gzmv mysql-5.7.39-linux-glibc2.12-x86_64 mysql-5.7.39

三、添加系統mysql組和MySQL用戶

cat /etc/group | grep mysqlmysql:x:27:cat /etc/passwd | grep mysqlmysql:x:27:27:MySQL Server:/var/lib/mysql:/sbin/nologin如無,執行添加命令:groupadd mysqluseradd -r -g mysql mysql

四、安裝數據庫

1.在解壓的MySQL目錄下創建data目錄


(資料圖)

mkdir data

2.將/usr/local/mysql/mysql-5.7的所有者及所屬組改為mysql

chown -R mysql.mysql /usr/local/mysql/mysql-5.7

3.在/usr/local/mysql/mysql-5.7/support-files目錄下創建my_default.cnf

cd support-files/vim my_default.cnf

并且寫入文件,保存覆蓋

[mysqld]sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESbasedir = /usr/local/mysql/mysql-5.7datadir = /usr/local/mysql/mysql-5.7/dataport = 3306socket = /tmp/mysql.sockcharacter-set-server=utf8log-error = /usr/local/mysql/mysql-5.7/data/mysqld.logpid-file = /usr/local/mysql/mysql-5.7/data/mysqld.pid

4.初始化 mysqld

cd /usr/local/mysql/mysql-5.7/./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-5.7/ --datadir=/usr/local/mysql/mysql-5.7.39/data/

5.初始化成功,在日志中查看默認密碼

cd /usr/local/mysql/mysql-5.7/data/

6.把啟動腳本放到開機初始化目錄

cp support-files/mysql.server /etc/init.d/mysql

7.登錄mysql,修改密碼,添加遠程訪問權限

見文章:

??https://blog.51cto.com/u_15227402/5907011??

8.重啟mysql生效

service mysql stop 關閉mysql

service mysql start 開啟mysql

service mysql restart 重啟mysql

標簽: 遠程訪問 修改密碼 默認密碼

上一篇:天天新動態:如何使用 Spring 創建“Hello, World”RESTful Web 服務
下一篇:全球新資訊:通過Console口登錄設備