1.虚拟机配置
1 设置网络适配器
2 设置静态ip
虚拟机中对应网卡的信息(在root下):
vim /etc/sysconfig/network-scripts/ifcfg-eth0
注:有的centOS可能初始网卡的名称不是eth0,可以自己修改一下名称(参考链接)
其中标注***
为必须要修改的
TYPE="Ethernet"
BOOTPROTO="static" ***
DEFROUTE="yes"
IPV4_FAILURE_FATAL="no"
IPV6_AUTOCONF="yes"
IPV6_DEFROUTE="yes"
IPV6_FAILURE_FATAL="no"
NAME="eth0"
UUID="ae679cf5-f894-4e23-8a82-60a220f69299"
DEVICE="eth0"
ONBOOT="yes" ***
IPADDR="192.168.34.52" ***
PREFIX="24"
GATEWAY="192.168.34.254" ***
DNS1="114.114.114.114" ***
IPV6INIT=no
修改其中字段:
BOOTPROTO:static,静态,IP不会改变
NMAE和DEVICE:要和自己网卡名称的一致
3 添加网关地址
GATEWAY与主机的网关一致
vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=compute
GATEWAY=192.168.34.254
如果能ping通网关,但是ping www.baidu.com时若出现“unknown host www.baidu.com”(可能是域名无法解析为ip),则使用命令“vi /etc/resolv.conf ” , 查看其中的DNS是不是114.114.114.114,不是可以修改为它。
nameserver 114.114.114.114
4 重启网络
service network restart
2.安装MySQL
1 查看是否已经安装 Mysql
rpm -qa | grep mysql
如果你查看出来有东西,可以使用下面命令将其删除
rpm -e 文件名
2.卸载相关依赖
rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-*
find / -name mysql
然后挨个删除
2 下载官方 Mysql 包
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar
3 安装MySQL包
tar xvf mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.31-1.el7.x86_64.rpm
4 启动MySQL并查看
systemctl start mysqld
service mysqld status
3.MySQL配置
# 查看mysql初始密码
grep 'password' /var/log/mysqld.log
# 进入mysql
mysql -u root -p
# 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';
# 允许远程链接
use mysql;
update user set host = '%' where user = 'root';
Grant all privileges on root.* to 'root'@'%';
FLUSH PRIVILEGES;
# navicat访问
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
# 修改当前用户密码
ALTER USER 'root'@'%' IDENTIFIED BY '你的密码';