一、環(huán)境準(zhǔn)備：

注意事項：

• 部署MySQL服務(wù)，需要避免其他數(shù)據(jù)庫軟件的干擾，比如mariadb，需要先停止其他服務(wù)再進(jìn)行安裝mysql

二、搭建MySql步驟

第一步：解壓mysql的tar包

• 解壓

[root@host50 ~]# tar -xf mysql-5.7.17.tar

• 查看解壓后的文件

[root@host50 ~]# ls mysql-community-*.rpm
mysql-community-client-5.7.17-1.el7.x86_64.rpm
mysql-community-common-5.7.17-1.el7.x86_64.rpm
mysql-community-devel-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.17-1.el7.x86_64.rpm
mysql-community-libs-5.7.17-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.17-1.el7.x86_64.rpm
mysql-community-server-5.7.17-1.el7.x86_64.rpm
mysql-community-test-5.7.17-1.el7.x86_64.rpm

第二步：安裝

• 安裝所有相關(guān)rpm軟件包

[root@host50 ~]# yum -y install mysql-community-*.rpm

第三步：啟動服務(wù)

[root@host50 ~]# systemctl enable --now mysqld

• 查看端口號

[root@host50 ~]# netstat  -utnlp  | grep  3306  
tcp6       0      0 :::3306                 :::*                    LISTEN      15167/mysqld 

• 查看進(jìn)程

[root@host50 ~]# ps aux | grep mysqld
[root@host50 ~]# ps -C mysqld
mysql     15167  0.0 17.4 1119536 173856 ?      Sl   19:20   0:04 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
root      16111  0.0  0.0 112824   976 pts/1    R+   22:35   0:00 grep --color=auto mysqld

第四步：配置初始密碼

• 查看服務(wù)初始密碼

[root@host50 ~]# grep -i password  /var/log/mysqld.log
..... password is generated for root@localhost: p.7jr.uy.aiZ

• 使用初始密碼連接服務(wù)

[root@host50 ~]# mysql -uroot -p'p.7jr.uy.aiZ'
mysql: [Warning] ....
....
Type 'help;' or '\h' for help. ...
mysql> 

• 使用初始密碼登錄是無法操作數(shù)據(jù)庫，所以需要修改密碼
• 修改密碼格式：alter user root@"localhost" identified by "新密碼";

# 修改密碼
mysql> alter user  root@"localhost" identified by "123qqq...A";
# 斷開連接
mysql> exit;

• 使用修改的密碼登錄

[root@host50 ~]# mysql  -uroot -p123qqq...A
mysql: [Warning] ....
....
Type 'help;' or '\h' for help. ...
mysql> 

• 簡單操作下數(shù)據(jù)庫

# 查看已有的庫 ，發(fā)現(xiàn)功能可以使用即可
mysql> show databases;  
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+