官網下載下傳位址
https://dev.mysql.com/downloads/file/?id=471503
本文所用MySQL版本為5.7.19;
上傳包
将mysql-5.7.19-1.el7.x86_64.rpm-bundle.tar 安裝包上傳到/opt/soft目錄（此目錄可以自定義）,采用rz指令；
[root@bigdata112 conf]# rz
若不存在rz指令，可以用yum進行安裝（如下代碼），安裝完成再執行rz 上傳包指令；
[root@bigdata112 ~]# yum install lrzsz
檢測是否已有mysql
[root@bigdata112 ~]# rpm -qa | grep mysql
檢測是否已有Mariadb
[root@bigdata112 mysql-5.7.19]# rpm -qa | grep mariadb
mariadb-libs-5.5.44-2.el7.centos.x86_64
若存在則解除安裝；
[root@bigdata112 mysql-5.7.19]# rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
解壓包
将mysql壓縮包解壓到/op/module/mysql-5.7.19目錄，若沒有則建立一個目錄；
因為我們下載下傳的是.tar壓縮包，是以指令為：tar -vxf
[root@bigdata112 ~]# tar -vxf /opt/soft/mysql-5.7.19-1.el7.x86_64.rpm-bundle.tar -C /opt/module/mysql-5.7.19/
安裝mysql
切換到/opt/module/mysql-5.7.19/目錄，依次執行以下指令：
安裝server
[root@bigdata112 mysql-5.7.19]# rpm -ivh --nodeps mysql-community-server-5.7.19-1.el7.x86_64.rpm
安裝client
[root@bigdata112 mysql-5.7.19]# rpm -ivh --nodeps mysql-community-client-5.7.19-1.el7.x86_64.rpm
安裝common
[root@bigdata112 mysql-5.7.19]# rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm
安裝libs
[root@bigdata112 mysql-5.7.19]# rpm -ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm
安裝libs-compat
[root@bigdata112 mysql-5.7.19]# rpm -ivh mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpm
啟動mysql服務
[root@bigdata112 mysql-5.7.19]# systemctl start mysqld
檢視mysql服務狀态
[root@bigdata112 mysql-5.7.19]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since 日 2019-09-08 21:36:35 CST; 1h 34min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 3474 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 3401 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 3478 (mysqld)
CGroup: /system.slice/mysqld.service
└─3478 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
9月 08 21:36:32 bigdata112 systemd[1]: Starting MySQL Server...
9月 08 21:36:35 bigdata112 systemd[1]: Started MySQL Server.
檢視預設生成的root密碼
[root@bigdata112 mysql-5.7.19]# cat /var/log/mysqld.log | grep password
2019-09-08T15:15:25.399553Z 1 [Note] A temporary password is generated for root@localhost: m5D_fhi6%y61
登入mysql
[root@bigdata112 mysql-5.7.19]# mysql -uroot -p'm5D_fhi6%y61'
修改mysql密碼規則
- 密碼強度檢查等級，0/LOW、1/MEDIUM、2/STRONG
mysql> set global validate_password_policy=0; - 密碼至少要包含的小寫字母個數和大寫字母個數
mysql> set global validate_password_mixed_case_count=0; - 密碼至少要包含的數字個數
mysql> set global validate_password_number_count=3; - 密碼至少要包含的特殊字元數
mysql> set global validate_password_special_char_count=0; - 密碼最小長度，參數預設為8
mysql> set global validate_password_length=3;
修改密碼
mysql> alter user root@localhost identified by 'root1234';
mysql> flush privileges;
測試mysql
顯示資料庫清單
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
顯示剛才設定的密碼規則
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------+-------+
| validate_password_check_user_name | OFF |
| validate_password_dictionary_file | |
| validate_password_length | 3 |
| validate_password_mixed_case_count | 0 |
| validate_password_number_count | 3 |
| validate_password_policy | LOW |
| validate_password_special_char_count | 0 |
+--------------------------------------+-------+
7 rows in set (0.00 sec)
修改遠端登入權限
查詢user表内使用者的登入權限
mysql> select host,user from mysql.user;
+-----------+---------------+
| host | user |
+-----------+---------------+
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+---------------+
3 rows in set (0.00 sec)
修改root登入權限為所有%
mysql> update mysql.user set host = '%' where user = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
重新整理緩存
mysql> flush privileges;
測試遠端登入權限
利用navicat用戶端建立連接配接，測試是否成功；
作者：ShadowFiend
出處：http://www.cnblogs.com/ShadowFiend/
本文版權歸作者和部落格園共有，歡迎轉載，但未經作者同意必須保留此段聲明，且在文章頁面明顯位置給出原文連接配接，否則保留追究法律責任的權利。如有問題或建議，請多多賜教，非常感謝。