于今日发现,可从mysql官网更方便的安装mysql服务记录
官网给出的仓库示例
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
注释gpgkey这一条,并且将gpgcheck=1更改为0
确保本机装有dns且能与外网互通
成都DNS地址(61.139.2.69)
yum repolist | grep mysql
yum list | grep mysql
检查是否配置完成
yum remove -y mysqllib
卸载本机自带的mysqllib;
yum install mysql-community-server -y
安装mysql
service mysqld start
grep 'temporary password' /var/log/mysqld.log
超级用户帐户 ‘root’@’localhost’被创建;用户的密码设置存储在错误日志文件中
2017-12-14T05:24:31.515812Z 1 [Note] A temporary password is generated for root@localhost: XSOPJl<(n3b9
mysql -uroot -p“XSOPJl<(n3b9”
登录mysql
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘X123.com’;
修改密码
MySQL5.7密码规范:8位数,且必须有数字,大小写字母
因Mysql5.7密码采用很复杂的模式,不方便记忆,可关闭该功能
并根据使用情况可加一些配置
vim /etc/my.cnf
validate_password = off (添加)
character_set_server=utf8
init_connect=’SET NAMES uft8’
max_allowed_packet=8388608
innodb_file_format=barracuda
innodb_file_per_table=1
查看官方原文网址