操作系統(tǒng)：CentOS7
安裝版本：mysql5.7
【官網(wǎng)】https://dev.mysql.com/downloads/mysql/
一、安裝準(zhǔn)備
1）查看是否有舊版本MySql，有就逐個(gè)刪除，避免沖突
rpm -qa | grep mysql
#rpm -e mysql.rpm --nodeps #--nodeps 此處為不驗(yàn)證依賴刪除儿倒，非必帶
2）清除yum里所有mysql依賴包
yum remove mysql-libs #個(gè)別是 mariadb-libs——yum remove mariadb-libs
3）查看是否有安裝libaio谬以，沒有則安裝
rpm -qa | grep libaio
#yum -y install libaio #沒有則安裝
二几缭、下載解壓安裝
1）下載mysql5.7全家桶
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar
1.png
2）解壓mysql5.7全家桶
tar -xvf mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar
2.png
3）按照依賴關(guān)系依次安裝rpm包派桩，依賴關(guān)系依次為common→libs→client→server
rpm -ivh mysql-community-common-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.32-1.el7.x86_64.rpm
# 可能會出現(xiàn)的報(bào)錯(cuò)
error: Failed dependencies:
libnuma.so.1()(64bit) is needed by mysql-community-server-5.7.32-1.el7.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by mysql-community-server-5.7.32-1.el7.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by mysql-community-server-5.7.32-1.el7.x86_64
# 需要安裝 numactl
yum install numactl -y
3.png
三腾誉、啟動mysql
1）mysql基本操作命令
systemctl start mysqld.service 啟動mysql
systemctl status mysqld.service 查看mysql狀態(tài)
systemctl stop mysqld.service 關(guān)閉mysql
查看mysql進(jìn)程 ps ax | grep mysql
查看3306端口 netstat -anop | grep 3306
2）啟動mysql及查看root的mysql原始登錄密碼
#service mysqld {start|stop|force-quit|restart|reload|status|configtest}
service mysqld start #啟動命令
grep 'temporary password' /var/log/mysqld.log
5.png
3）輸出命令椭盏，用戶是root组砚，密碼是剛剛查看的那個(gè)，成功進(jìn)入后就安裝成功了
mysql -uroot -p4）在5.6后,mysql內(nèi)置密碼增強(qiáng)機(jī)制,低強(qiáng)度密碼會報(bào)錯(cuò),需要重新設(shè)置密碼
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
set password for root@localhost=password('password');
5）授予root用戶遠(yuǎn)程訪問權(quán)限
#（注意：下面命令開啟的IP是 192.168.31.132掏颊，如要開啟所有的糟红，用%代替IP）
mysql> use mysql;
mysql> grant all privileges on *.* to 'root'@'192.168.31.132' identified by 'password' with grant option;
mysql> flush privileges;
# root 是用戶，192.168.31.132是指定IP乌叶，%是所有IP盆偿，password是root用戶遠(yuǎn)程登錄的密碼
ps：MySQL8不支持上面遠(yuǎn)程訪問權(quán)限配置，MySQL8的請使用以下方法
mysql> use mysql;
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'root'; # 創(chuàng)建用戶
mysql> GRANT ALL privileges on *.* to 'root'@'%'; # 賦予權(quán)限
mysql> alter user 'root'@'%' identified with mysql_native_password by 'root'; #更新用戶密碼
mysql> flush privileges; # 刷新權(quán)限
