Centos7安装配置mysql
原创
©著作权归作者所有:来自51CTO博客作者liuyunshengsir的原创作品,请联系作者获取转载授权,否则将追究法律责任
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 安装
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;