openEuler 22.03 LTS安装MySQL8.0踩坑记录
安装MySQL8.0步骤
①下载MySQL8.0
官方下载
下载地址：https://dev.mysql.com/downloads/mysql/
x86_64下载直连：https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.29-1.el8.x86_64.rpm-bundle.tar
国内镜像站加速
清华大学开源软件镜像站：https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-8.0/ x86_64下载直连：https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-8.0/mysql-8.0.29-1.el8.x86_64.rpm-bundle.tar
②安装MySQL8.0
解压下载的安装包
tar -xvf mysql-8.0.29-1.el8.x86_64.rpm-bundle.tar
按照顺序安装
rpm -ivh mysql-community-common-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-server-8.0.29-1.el8.x86_64.rpm
③安装好后初始化
mysqld --initialize --user=mysql
④启动命令和常见命令
systemctl start mysqld #启动MySQL
systemctl enable mysqld #开机启动MySQL
systemctl restart mysqld #重新启动MySQL
⑤查看root密码
grep 'temporary password' /var/log/mysqld.log
⑥登录MySQL
mysql -uroot -p
⑦修改MySQL密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '填写密码';
遇到的问题
使用Navicat Premium登录时提示
/etc/ssh/sshd_config 将日志级别调整到 LogLevel VERBOSE
发现无法转发端口
搜索发现这篇文章：https://gss-portal.com/knowledgebase/140/refused-local-port-forward-originator-error.html
提到可能是ssh设置了不允许转发tcp请求 用文本编辑器打开
vim /etc/ssh/sshd_config
AllowTcpForwarding no#改为yes即可
重启 SSH 服务：
systemctl restart sshd