一奄抽、配置Mysql擴(kuò)展源
rpm -ivh http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql57-community-release-el7-10.noarch.rpm
二看蚜、yum安裝mysql
yum install mysql-community-server -y
三叫搁、啟動(dòng)Mysql，并加入開(kāi)機(jī)自啟
systemctl start mysqld
systemctl enable mysqld
四、使用Mysq初始密碼登錄數(shù)據(jù)庫(kù)
mysql -uroot -p$(awk '/temporary password/{print $NF}' /var/log/mysqld.log)
五渴逻、修改數(shù)據(jù)庫(kù)密碼
數(shù)據(jù)庫(kù)默認(rèn)密碼規(guī)則必須攜帶大小寫(xiě)字母疾党、特殊符號(hào)烂翰，字符長(zhǎng)度大于8否則會(huì)報(bào)錯(cuò)宛裕。
因此設(shè)定較為簡(jiǎn)單的密碼時(shí)需要首先修改set global validate_password_policy和_length參數(shù)值惹悄。
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)
六盗似、修改密碼
mysql> set password for root@localhost = password('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)
七垫言、登錄測(cè)試
[root@http-server ~]# mysql -uroot -p123456
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql> exit
