centos7安装MySQL
2020-12-23 本文已影响0人
攻城老狮
- 安装可用的rpm包
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
- 安装mysql服务
yum -y install mysql-community-server
- 启动mysql
systemctl start mysqld.service
- 查看mysql服务状态
systemctl status mysqld.service
- 查找日志获取随机的初始密码
grep "password" /var/log/mysqld.log
- 登录数据库
mysql -uroot -p
- 修改密码
# 修改密码复杂度
set global validate_password_policy=LOW;
set global validate_password_length=6;
# 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
- 开启mysql远程访问
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;
- 关闭防火墙
systemctl stop firewalld.service
- 修改默认编码
vim /etc/my.cnf
[client]
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
20200807125012307.png
- 重启服务
service mysqld restart
- 查看修改是否成功
show variables like '%character%';
