直接上操作命令:
apt install rpm
下载MySQL 5.7仓库
rpm -ivh https://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
导入MySQL软件包GPG密钥文件
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
安装MySQL软件包
apt install mysql-server
sudo vim /etc/mysql/debian.cnf 这里修改密码
systemctl start mysql 启动mysql
mysql -u root -p 连接mysql
输入密码。
create user 'frank'@'%' IDENTIFIED BY '123456'; 创建用户
GRANT ALL PRIVILEGES ON *.* TO 'frank'@'%' WITH GRANT OPTION; 授权
flush privileges; 刷新
如果需要远程链接 还需要修改bind-address
vim /etc/mysql/mysql.conf.d/mysqld.cnf
需要设置成0.0.0.0
然后重启mysql服务
systemctl restart mysql
使用远程工具连接,DBeaver 出现 Public Key Retrieval is not allowed ,如下图解决