CentOS7.5下，MySQL安装配置指南

[root@host-10-133-1-134 home]# grep 'temporary password' /var/log/mysqld.log
2019-03-20T02:21:56.457613Z 1 [Note] A temporary password is generated for root@localhost: qAD44%hu?afp

 

[root@host-10-133-1-134 home]# uname -a
Linux host-10-133-1-134 3.10.0-862.el7.x86_64 #1 SMP Fri Apr 20 16:44:24 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
[root@host-10-133-1-134 home]# cat /etc/os-release
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"
[root@host-10-133-1-134 home]# cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)

[root@host-10-133-1-134 home]# rpm -qa | grep mysql
[root@host-10-133-1-134 home]# rpm -qa | grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64

[root@host-10-133-1-134 home]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
[root@host-10-133-1-134 home]# rpm -qa | grep mariadb
[root@host-10-133-1-134 home]# rpm -qa | grep mysql

[root@host-10-133-1-134 home]# rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
warning: mysql-community-common-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-5.7.25-1.e################################# [100%]
[root@host-10-133-1-134 home]# rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
warning: mysql-community-libs-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-libs-5.7.25-1.el7################################# [100%]
[root@host-10-133-1-134 home]# rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
warning: mysql-community-client-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-client-5.7.25-1.e################################# [100%]
[root@host-10-133-1-134 home]# rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-server-5.7.25-1.e################################# [100%]

systemctl start mysqld.service    //启动mysql
systemctl status mysqld.service  //查看mysql状态
systemctl stop mysqld.service    //关闭mysql

[root@host-10-133-1-134 home]# ps -ef | grep mysql
mysql    24891     1  0 10:21 ?        00:00:00 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
root     24978 24025  0 10:28 pts/1    00:00:00 grep --color=auto mysql
[root@host-10-133-1-134 home]# netstat -nltp|grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN      24891/mysqld

[root@host-10-133-1-134 home]# grep 'temporary password' /var/log/mysqld.log
2019-03-20T02:21:56.457613Z 1 [Note] A temporary password is generated for root@localhost: qAD44%hu?afp

//使用如下命令登录数据库，输入上面查询到的密码：
[root@host-10-133-1-134 ~]# mysql -u root -p

//进入数据库，使用命令set password=password("Huawei12#$");修改数据库密码。

mysql> grant all privileges on *.* to root@"%" identified by "Huawei12#$";
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

//配置字符编码UTF-8
//vi /etc/my.cnf
#添加
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'


配置文件：/etc/my.cnf 
日志文件：/var/log//var/log/mysqld.log 
服务启动脚本：/usr/lib/systemd/system/mysqld.service 
socket文件：/var/run/mysqld/mysqld.pid