wget http://repo.mysql.com/mysql57-community-release-el7-9.noarch.rpm
sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm
# 更新yum软件包
yum check-update
# 更新系统
yum update
#安装mysql
yum install mysql mysql-server
systemctl start mysqld
查看初始化密码
为了加强安全性,MySQL5.7为root用户随机生成了一个密码,在error log中,关于error log的位置,如果安装的是RPM包,则默认是/var/log/mysqld.log。 只有启动过一次mysql才可以查看临时密码
grep 'temporary password' /var/log/mysqld.log
设置密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Easy.8888';
允许外网直接 连接数据库(高风险)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
禁止外网连接数据库
DELETE FROM user where user = "root" and host = "%";
FLUSH PRIVILEGES;
禁用大小写敏感(建议)
进入etc下面
编辑my.cnf文件
cd /etc/
vi my.cnf
最后一行加上下面一句
lower_case_table_names=1
重启mysql:
systemctl restart mysqld