下载-yum
- 官方yum源RPM安装包
http://dev.mysql.com/downloads/repo/yum/
- wget下载
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm
- 检测mysql源是否安装成功
yum repolist enabled | grep "mysql.-community."
- mysql默认源修改
vim /etc/yum.repos.d/mysql-community.repo
注意enabled=1的表示默认
安装
- yum安装
yum install mysql-community-server
没啥说的一路YES
开启
- 启动
systemctl start mysqld
- 重启
systemctl restart mysqld
- 关闭
systemctl stop mysqld
- 默认密码查看
grep 'temporary password' /var/log/mysqld.log
- 登录
mysql -uroot -p
- 退出
quit;
配置
- 开机启动
systemctl enable mysqld
systemctl daemon-reload
- 密码修改
注意:大小写字母、数字和特殊符号,并且长度不能少于8位
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Lowercasealphabet100!';
- 配置默认编码为utf8
vim /etc/my.cnf
追加下面的配置并且重启
character_set_server=utf8
init_connect='SET NAMES utf8'
- 配置远程访问
GRANT ALL PRIVILEGES ON . TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
- 配置查看
密码策略
show variables like '%password%';
字符编码
show variables like '%character%';