CentOS 7 YUM安装与配置mysql 5.7

1.安装mysql 5.7的Yum源

#rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

可以修改/etc/yum.repos.d/mysql-community.repo源来改变默认安装的mysql版本,比如要安装5.6则将5.7源中的enabled=1修改为enabled=0,再将5.6源中的enabled=0修改为enabled=1.如下图:

2.安装mysql

#yum install -y mysql-community-server

3.修改mysql存贮目录

建立数据库存贮目录

#mkdir /home/data/mysql

#chown mysql:mysql -R /home/data/mysql

修改配置文件

#vim /etc/my.cnf

找到datadir=/var/lib/mysql和socket=/var/lib/mysql/mysql.sock,并将其修改为

datadir=/home/data/mysql

socket=/home/data/mysql/mysql.sock

建立软链接

ln -s /home/data/mysql/mysql.sock /var/lib/mysql/mysql.sock

4.启动mysql服务

#systemctl start mysqld

查看启动状态

#systemctl status mysqld
● mysqld.service – MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since 一 2018-01-08 10:43:48 CST; 4h 24min ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
Main PID: 23400 (mysqld)
   CGroup: /system.slice/mysqld.service
           └─23400 /usr/sbin/mysqld –daemonize –pid-file=/var/run/mysqld/mysqld.pid

1月 08 10:43:41 lnmt.caihuang.com systemd[1]: Starting MySQL Server…
1月 08 10:43:48 lnmt.caihuang.com systemd[1]: Started MySQL Server.

5.将mysql设为开机启动

#systemctl enable mysqld

#systemctl daemon-reload

6.修改mysql root密码

mysql安装完成后,在/var/log/mysqld.log保存有安装生成的默认密码:

# grep ‘temporary password’ /var/log/mysqld.log
2018-01-08T02:43:42.968699Z 1 [Note] A temporary password is generated for root@localhost: oRahty0sKL_d

# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.20 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourP@ssW0rd!';

请注意密码安全策略,可用以下命令查看