Centos7 安装 Mysql 数据库

 Centos 7.4 64 位
 Mysql 5.7

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

yum localinstall mysql57-community-release-el7-8.noarch.rpm

yum repolist enabled | grep "mysql.*-community.*"

yum install mysql-community-server

systemctl start mysqld
//如此类推
systemctl stop mysqld
systemctl restart mysqld

//第二种，容易记
service msyqld start
service msyqld stop
service msyqld restart

systemctl enable mysqld
systemctl daemon-reload

[root@VM_65_249_centos ~]# grep 'temporary password' /var/log/mysqld.log
2018-06-13T04:04:42.144765Z 1 [Note] A temporary password is generated for root@localhost: #5ejRwZBgquL

mysql -u root -p 

set password for 'root'@'localhost'=password('YourNewPassword123!'); 

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements //不通过密码安全插件检查

GRANT ALL PRIVILEGES ON *.* TO 'ppjun'@'%' IDENTIFIED BY 'YourNewPassword123!' WITH GRAN;

vi /etc/my.cnf 

[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'

mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)