MySQL8安装配置
1. 首先查看系统是否存在mysql
rpm -qa|grep mysql
2. 安装wget
yum -y install wget
3.mariadb删除,无则不返回
rpm -qa|grep mariadb
4.删除mariadb
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
5.配置阿里云的yum
cd /etc/yum.repos.d/
wget http://mirrors.aliyun.com/repo/Centos-7.repo
mv CentOS-Base.repo CentOS-Base.repo.bak
mv Centos-7.repo CentOS-Base.repo
yum clean all
yum makecache
yum update
6. 下载rpm包
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
7.配置mysql rpm源
sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
执行成功后会在/etc/yum.repos.d/目录下生成两个repo文件mysql-community.repo 及 mysql-community-source.repo
8. 安装Mysql
cd /etc/yum.repos.d/
ll
yum install -y mysql-community-server
最后提示失败的软件包 -------,这里需要升级GPG配置(2022为年份), 然后重新执行上面的安装命令
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum install -y mysql-community-server
9.MySQL相关配置
9.1启动MYSQL服务,并查看状态,查看端口
systemctl start mysqld --启动mysql服务
systemctl status mysqld --查看mysql服务状态
netstat -nlpt | grep mysqld --查看端口
9.2设置开机启动
systemctl enable mysqld
systemctl daemon-reload
9.3获取临时密码
cat /var/log/mysqld.log | grep password
9.4登录进mysql
mysql -u<账号> -p<密码> -P<端口号,默认3306> -h<mysqld服务器IP,如果比指定"-h" 则表示本地登陆> #此为mysql登录命令格式
mysql -uroot -p
9.5修改密码
mysql8 默认是强密码,需要先改密码后再调整密码强度(命令结尾加 ; )
mysql> alter user 'root'@'localhost' identified by 'Mysql@password123'; --修改密码(强密码)
mysql> flush privileges; --刷新,立即生效
mysql> select user,host from mysql.user; --查看数据库中账号信息
mysql> set global validate_password.policy=0; --关掉强密码认证
mysql> set global validate_password.length=6; --密码长度最短为6位数
mysql> alter user 'root'@'localhost' identified by '123456'; --修改密码(弱密码)
flush privileges;
9.6开放端口
开放3306端口,并且重启防火墙,然后查看端口,开放端口是为了外网能通过Navicat Premium等其他工具访问
# firewall-cmd --zone=public --add-port=3306/tcp --permanent --开放3306端口
# firewall-cmd --reload --重启防火墙
# firewall-cmd --list-ports --查看开放的端口
或关闭防火墙
systemctl stop firewalld
9.7 登录进到数据库,修改user表中的Host,添加远程访问权限
create user root@'%' identified by '123456';
grant all privileges on *.* to root@'%' with grant option;
flush privileges;