在centos7.9使用yum安装mysql5.7.x
安装yum管理包
yum -y install yum-utils获取安装mysql源
wget https://repo.mysql.com//mysql80-community-release-el7-7.noarch.rpm
rpm -ivh mysql80-community-release-el7-7.noarch.rpm导入公钥
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022停用mysql8源
yum-config-manager --disable mysql80-community启用mysql5源
yum-config-manager --enable mysql57-community安装mysql server和cli
yum install -y mysql-community-server mysql启动并加入自启
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld查看初始密码
grep "A temporary password" /var/log/mysqld.log修改root密码
mysql -u root -p
在mysql客户端中执行:
ALTER USER 'root'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY 'xx';
flush privileges;创建一个数据库
create database test1创建库用户test-并给它test1库最高权限
create user 'test'@'localhost' identified by 'xx';
GRANT ALL ON test1.* TO 'test'@'localhost';
flush privileges;连接测试
mysql -u test -p
感谢