一.基础环境:
实验环境
1.本机为桌面安装
2.网络模式为nat ip:172.20.10.8
基础环境
1.可以ping通网络及网络设置
2.挂载镜像,及配置yum源仓库
最小安装需下载依赖环境
[root@ ~]#yum -y install wget.x86_64
[root@ ~]#yum -y install vim
[root@ ~]#yum -y install bash-completion
[root@ ~]#bash
二.安装Mysql并配置
1.检查基础环境是否预留mysql或mariadb的包:
查询是否安装了MySQL了
[root@G]# cd /etc/yum.repos.d
[root@G yum.repos.d]# rpm -qa | grep mysql
[root@G yum.repos.d]# rpm -qa | grep mariadb mariadb-libs-5.5.68-1.el7.x86_64
#强制卸载mariadb-lib
[root@G yum.repos.d]# rpm -e --nodeps mariadb-libs
[root@G yum.repos.d]# rpm -qa | grep mariadb
#安装mysql数据库
[root@G yum.repos.d]# wget https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm #从网上获取mysql.rpm包
#安装rpm包
[root@G yum.repos.d]# rpm -ivh mysql80-community-release-el7-5.noarch.rpm
#清空缓存
[root@G ~ yum.repos.d]# yum makecache fast [root@G ~yum.repos.d]# yum repolist
2.安装mysql数据库及登录,修改密码
[root@G yum.repos.d]# yum -y install mysql-community-server
[root@G yum.repos.d]# grep "passwor" /var/log/mysqld.log 2022-04-15T01:10:12.626454Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: RbSv)lzrG6ts [root@G yum.repos.d]# mysql -u root -p Enter password: mysql> set password='LGC@liu0301'; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye
3.设置允许远程访问
[root@G ~]systemctl stop firewalld.service
[root@G ~]systemctl disable firewalld.service
4.修改mysql权限允许任何人连接
[root@G yum.repos.d]# mysql -u root -p Enter password: mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select Host,User from user; +-----------+------------------+ | Host | User | +-----------+------------------+ | localhost | mysql.infoschema | | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | +-----------+------------------+ 4 rows in set (0.00 sec) mysql> update user set Host='%' where User='root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> exit Bye
5.使用连接工具:使用Navicat连接工具测试
新建---mysql 注:密码为数据库密码 主机为虚拟机ip地址(密码要手动输入)