一、下载与安装
1、下载yum配置
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
2、rpm安装
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
3、安装签名key
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
4、yum安装
yum install mysql-server
二、配置
1、不区分大小写
1)编辑配置
vi /etc/my.cnf
2)修改[mysqld]配置
lower_case_table_names=1
说明:lower_case_table_names[1:不敏感,0:敏感]
2、启动
systemctl start mysqld.service
3、查看状态
systemctl status mysqld.service
4、查看初始化密码
grep "password" /var/log/mysqld.log
5、修改密码
1)修改root本地密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'x5eZvhbmh3J@3H1ERc77';
说明: 需要复杂一些,简单会失败(20位可以)
说明2: 附随机密码在线生成
6、修改远程可连接
1)选择数据库
use mysql;
2)修改远程可访问
update user set host = '%' where user = 'root';
3)设置远程加密方式,防治连接1251
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'x5eZvhbmh3J@3H1ERc77';
4)刷新生效
flush privileges;
7、配置开机自启
1)复制mysqld
cp /usr/lib/systemd/system/mysqld.service /etc/rc.d/init.d/mysqld
2)编辑配置文件
vi /etc/rc.d/init.d/mysqld
3)增加内容
# chkconfig: 2345 10 90
示例图:
4)设置开机自启
chkconfig --add mysqld
5)设置重启级别
chkconfig --level 3 mysqld on
6)查看是否加入成功
chkconfig --list