Centos7安装配置mysql

1.配置yum源

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

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

2.yum 安装

yum install mysql-server

3.替换配置文件

[client]
# 设置mysql客户端默认字符集
default-character-set=utf8
socket=/tmp/mysql.sock
[mysqld]
collation-server=utf8_general_ci
datadir=/usr/local/mysql/data
log-error=/var/log/mysqld.log
port=3306
socket=/tmp/mysql.sock
max_connections=500
max_user_connections=500
wait_timeout=200
character-set-server=utf8
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=16M
#设置sql_mode
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
innodb_lock_wait_timeout = 300

4.启动服务

确保配置文件中的路径都已经创建好了

service mysqld start
然后在  /var/log/mysqld.log 文件中会自动生成一个随机的密码，我们需要先取得这个随机密码，以用于登录 MySQL 服务端
grep "password" /var/log/mysqld.log

2018-09-01T09:04:28.487900Z 1 [Note] A temporary password is generated for root@localhost: hkciZSF?,7tz

5.登录到 MySQL 服务端并更新用户 root 的密码

mysql -u root -p   密码 进入


SET PASSWORD = PASSWORD('QQww@1122');

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

flush privileges;

#设置用户 root 可以在任意 IP 下被访问：

grant all privileges on *.* to root@"%" identified by "QQww@1122";

#设置用户 root 可以在本地被访问：

grant all privileges on *.* to root@"localhost" identified by "QQww@1122";

#刷新权限使之生效：

flush privileges;