入門linux基礎之mysql部署實驗篇

masql官網：www.mysql.com

有網絡的安裝方法

第一步：

關閉防火牆：systemctl stop firewalld

開機不啟動防火牆：systemctl disable firewalld

關閉selinux：setenforce 0

永久關閉selinux ： vim /etc/selinux/config SELINUX=disabled

第二步：

安裝Mysql伺服器

1.通路國内mysql鏡像站

2.下載下傳軟體包

wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-server-5.7.25-1.el7.x86_64.rpm

wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-client-5.7.25-1.el7.x86_64.rpm

wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-common-5.7.25-1.el7.x86_64.rpm

wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-libs-5.7.25-1.el7.x86_64.rpm

3.安裝相關軟體

yum install -y net-tools.x86_64 libaio.x86_64 perl.x86_64

4.安裝Mysql伺服器

yum install -y mysql-community*

可能會與資料庫mariadb沖突yum -y remove解除安裝之後再安裝

yum install -y mysql-community*

5.啟動Mysql伺服器

systemctl start mysqld 啟動

systemctl enable mysqld 開機啟動

systemctl status mysqld 檢視運作狀态

6.查詢Mysql伺服器預設密碼

grep ‘password’ /var/log/mysqld.log

檢視密碼，冒号空格後面全是密碼

7.修改Mysql伺服器密碼

mysqladmin -uroot -p’es,W;ya(K1Th’ password ‘[email protected]’

8.登入Mysql系統

mysql -uroot -p’[email protected]’

mysql -uroot -p

兩種都可以 ！