MYSQL Linux配置-CSDN博客

本文链接：https://blog.csdn.net/weixin_45322373/article/details/128885401

MYSQL下载

点击链接下载安装包，放入linux

把安装包解压到文件夹中

tar -xvf mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar

先下载 openssl-devel 插件

yum install openssl-devel

依次安装rpm包

rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm 
rpm -ivh mysql-community-libs-8.0.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.26-1.el7.x86_64.rpm
rpm -ivh  mysql-community-devel-8.0.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.26-1.el7.x86_64.rpm
rpm -ivh  mysql-community-server-8.0.26-1.el7.x86_64.rpm

启动Mysql

systemctl start mysqld

查看密码

cat /var/log/mysqld.log

连接mysql

mysql -u root -p

输入密码回车进入mysql模式

修改root密码

ALTER  USER  'root'@'localhost'  IDENTIFIED BY '密码';

服务器开放端口3306

root用户赋予远程连接权限

mysql>CREATE USER 'root'@'%' IDENTIFIED BY '密码';
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

成功了！

==============

Linux-安装MySQL（细教程）_多加点辣也没关系的博客-CSDN博客_linux mysql

Mysql 8.0 授权root 用户_itjava0311的博客-CSDN博客

连接远程mysql数据库失败常见原因及解决办法