云服务器或者虚拟机都可以;
Linux的版本为 CentOS7;
相关博客:VMware Workstation 安装CentOS Linux操作系统 利用远程控制软件FinalShell远程连接虚拟机上的Linux系统(Windows)
mkdir mysql
tar -xvf mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar -C mysql
cd mysql
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
yum install openssl-devel
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
yum -y remove mariadb-libs.x86_64
systemctl start mysqld //启动mysqld
systemctl restart mysqld //重启mysqld
systemctl stop mysqld //停止mysqld
grep 'temporary password' /var/log/mysqld.log
命令行执行指令 :
mysql -u root -p
然后输入上述查询到的自动生成的密码, 完成登录 .
登录到MySQL之后,需要将自动生成的不便记忆的密码修改了,修改成自己熟悉的便于记忆的密码。
ALTER USER 'root'@'localhost' IDENTIFIED BY '1234';
执行上述的SQL会报错,原因是因为设置的密码太简单,密码复杂度不够。我们可以设置密码的复杂度为简单类型,密码长度为4。
我们修改其为低等级
set global validate_password.policy = 0;
set global validate_password.length = 4;
降低密码的校验规则之后,再次执行上述修改密码的指令。 成功
默认的root用户只能当前节点localhost访问,是无法远程访问的,我们还需要创建一个root账户,用户远程访问
create user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '1234';
grant all on *.* to 'root'@'%';
mysql -u root -p
systemctl stop firewalld.service //关闭防火墙
systemctl disabled firewalld.service //防止自启动
sudo systemctl start firewalld //启动防火墙
firewall-cmd --zone=public --add-port=3306/tcp --permanent //开放3306端口
firewall-cmd --reload //重新登录