CentOS7离线安装mysql8.0并设置忽略大小写+远程连接
1. 下载离线安装包
下载地址1:https://dev.mysql.com/downloads/mysql/
下载地址2:https://download.csdn.net/download/D15306354614/15011142
2. 将tar压缩包上传到服务器
3. 删除原有mariadb
先查看一下是否已经安装了 命令:rpm -qa|grep mariadb
删除mariadb 命令:rpm -e --nodeps mariadb-libs
4. 检查 MySQL 是否已安装
yum list installed | grep mysql
如果有的话 就全部卸载
yum -y remove +数据库名称
5. 解压缩mysql离线安装包
tar -xvf mysql-8.0.23-2.el7.x86_64.rpm-bundle.tar
6. 安装rpm包
【必须安装】
rpm -ivh mysql-community-common-8.0.23-2.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.23-2.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.23-2.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.23-2.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.23-2.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.23-2.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.23-2.el7.x86_64.rpm
【非必须安装】
rpm -ivh mysql-community-test-8.0.23-2.el7.x86_64.rpm
7.设置忽略大小写
mysql安装完在启动前修改 /etc/my.cnf文件,
添加配置:lower_case_table_names=1
8. 初始化数据库
mysqld --initialize --console
9. 启动数据库服务
启动服务命令: systemctl start mysqld
查看服务状态命令: systemctl status mysqld
10. 查看初始默认密码
grep "password" /var/log/mysqld.log
11. 登陆mysql
命令:mysql -u root -p 回车键
然后输入临时密码(输入时不会显示出来,输入完直接回车)
12. 修改密码
alter USER 'root'@'localhost' IDENTIFIED BY '密码';
13. 授权远程连接
use mysql;
update user set host = "%" where user='root';
flush privileges;
14. 防火墙开放3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
尝试使用navacat远程连接,如果出现如下错误
2059 - Authenticationplugin‘caching_sha2_password’ cannot be loaded:XXXXX
解决办法:
命令:mysql -u root -p(回车后,输入更改后的密码)
命令:use mysql;
命令:alter USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
命令:flush privileges;
设置开机启动mysql服务
设为开机启动:systemctl enable mysqld
附录
创建远程登陆用户
create user 'root'@'%' identified by '密码'; #创建用户
grant all on *.* to 'root'@'%' with grant option; #授权
flush privileges; #刷新权限
服务命令
启动服务: systemctl start mysqld
关闭服务: systemctl stop mysqld
重启服务: systemctl restart mysqld