下载rpm包:
cd /opt
wget http://repo.mysql.com/mysql80-community-release-el7.rpm
安装:
rpm -Uvh mysql80-community-release-el7.rpm
yum install -y mysql-community-server
如果遇到错误:Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
则需要在线运行:rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
初始化:
mysqld --initialize
授权:
chown mysql:mysql /var/lib/mysql -R
启动:
systemctl start mysqld.service
开机自启:
systemctl enable mysqld
查看密码:
cat /var/log/mysqld.log | grep password
mysql -uroot -p
修改密码为root:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
安装完mysql记得导入数据表
【可选步骤】
1、配置忽略大小写敏感:
在centos中mysql是默认大小写敏感的
#让MYSQL大小写不敏感(0:敏感,1:不敏感)
修改/etc/my.cnf
添加一行:lower_case_table_names=1
重启mysql: systemctl restart mysqld
如果遇到启动失败,请备份好data数据后删除掉再试【datadir=/var/lib/mysql】
注意:删除时需要连同mysql目录删掉,不是mysql目录里面的内容
2、配置远程登录:
mysql -uroot -p
#修改root用户远程连接配置(记得开放端口后测试):
mysql>use mysql;
mysql>update user set host='%' where user='root';
mysql>flush privileges;
# 创建用户 root1, 密码 root1
mysql> create user 'mysql'@'%' identified with mysql_native_password by 'mysql的新密码';
#还可以修改密码操作
mysql>use mysql;
mysql> alter user 'mysql'@'%' identified with MYSQL_NATIVE_PASSWORD BY '新密码';
# 授权
mysql> grant all privileges on *.* to 'mysql'@'%' with grant option;
# 刷新修改后的权限
mysql> flush privileges;
删除远程连接的用户:
drop user 'mysql'@'%';
附上卸载步骤:
查看安装了mysql的那些包
[root@OS1~]$ rpm -qa | grep mysql
mysql-community-common-8.0.28-1.el7.x86_64
mysql-community-client-plugins-8.0.28-1.el7.x86_64
mysql-community-client-8.0.28-1.el7.x86_64
mysql-community-icu-data-files-8.0.28-1.el7.x86_64
mysql-community-libs-compat-8.0.28-1.el7.x86_64
mysql-community-libs-8.0.28-1.el7.x86_64
[root@OS1 ~]# rpm -e --nodeps mysql-community-common-8.0.28-1.el7.x86_64
[root@OS1 ~]# rpm -e --nodeps mysql-community-client-plugins-8.0.28-1.el7.x86_64
[root@OS1 ~]# rpm -e --nodeps mysql-community-client-8.0.28-1.el7.x86_64
[root@OS1 ~]# rpm -e --nodeps mysql-community-icu-data-files-8.0.28-1.el7.x86_64
[root@OS1 ~]# rpm -e --nodeps mysql-community-libs-compat-8.0.28-1.el7.x86_64
[root@OS1 ~]# rpm -e --nodeps mysql-community-libs-8.0.28-1.el7.x86_64
查看mysql安装目录
[root@OS1 ~]# whereis mysql
#删掉之
#[root@OS1 ~]# whereis my.cnf
删掉之
查找mysql 目录、文件
[root@OS1 ~]# find / -name mysql
./etc/selinux/targeted/active/modules/100/mysql
./var/lib/mysql
./var/lib/mysql/mysqll
删除相关目录、文件
[root@OS1 ~]# rm -rf xxxxxx
可检查是否删除mysql配置文件
rm –rf /usr/my.cnf
rm -rf /root/.mysql_sercret
可检查是否需要取消mysql开机启动项
systemctl disable mysqld