安裝MySQL

? 本次安裝使用的是綠色硬盤版本，無需額外安裝依賴環(huán)境，比較簡單

cd /opt
tar -xf mysql安裝包
mv 解壓出的目錄 /usr/local/mysql
#創(chuàng)建程序用戶
useradd -M -s /sbin/nologin mysql
#mysql的主配置文件設(shè)定所屬用戶和組
chown -R mysql.mysql /usr/local/mysql/
chown mysql.mysql /etc/my.cnf

修改配置文件：

vim /etc/my.cnf
[client]
port = 3306
#客戶端訪問的端口
socket=/usr/local/mysql/mysql.sock
#指定MySQL的通信套接字文件[mysqld]
user = mysql
basedir=/usr/local/mysql
#MySQL的安裝目錄
datadir=/usr/local/mysql/data
#MySQL數(shù)據(jù)保存的目錄
port = 3306
#服務(wù)端的端口
character-set-server=utf8
#字符集的編碼
pid-file = /usr/local/mysql/mysqld.pid
#pid文件位置
socket=/usr/local/mysql/mysql.sock
bind-address = 0.0.0.0
#表示任意地址都可以訪問數(shù)據(jù)庫
skip-name-resolve
max_connections=2048
default-storage-engine=INNODB
#MySQL默認(rèn)的存儲(chǔ)引擎
max_allowed_packet=16M
server-id = 1
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
#MySQL支持的數(shù)據(jù)類型和相關(guān)的模塊

設(shè)置環(huán)境變量，聲明/宣告MySQL命令便于系統(tǒng)識(shí)別：

echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile

? 初始化數(shù)據(jù)庫：

cd /usr/local/mysql/bin/
./mysqld \
--initialize-insecure \
--user=mysql \
--basedir=/usr/local/mysql \
--datadir=/usr/local/mysql/data

? 設(shè)置系統(tǒng)識(shí)別，進(jìn)行操作：

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
systemctl daemon-reload
systemctl restart mysqld

初始化數(shù)據(jù)庫密碼：

mysqladmin -u root -p password "123456"
#在交互界面直接回車，不要輸入！

進(jìn)入數(shù)據(jù)庫：

mysql -u root -p123456
#進(jìn)入數(shù)據(jù)庫交互界面
show databases;
#創(chuàng)建用戶并設(shè)置密碼
create user 'root'@"%" identified by '123456';
#賦予遠(yuǎn)程連接的權(quán)限
grant all privileges on *.* to 'root'@'%';
#刷新生效
flush privileges;
#修改加密方式，可以進(jìn)行遠(yuǎn)程連接
alter user 'root'@'%' identified with mysql_native_password by "123456";
exit;