MySQL安装 虚拟机配置 centOS

1、静态网段
1. VM ware 设置nat 网段 跟下述网段一致

2. cd /etc/sysconfig/network-scripts/
3. mv ifcfg-ens** ifcfg-eth0
4. vi ifcfg-eth0

5. 修改配置文件
BOOTPROTO=static ONBOOT=yes IPADDR=192.168.1.* GATEWAY=192.168.1.2 NETMASK=255.255.255.0 DNS1=192.168.122.2 DNS2=114.114.114.114

7. 重启网络服务
systemctl restart network
8. ip address

2、mysql8.0安装
1. 查看是否安装了MySQL rpm -qa | grep mysql
2. 移除相关配置文件 rm -rf /etc/my.cnf
3. 移除相关mysql的安装包
4. find / -name mysql
5. rm -rf msql 相关文件夹
6. 修改文件夹的权限 chmod -777 /tmp
7. 查询是否安装相关库 rpm -qa | grep libaio
8. rpm -qa | grep net-tools
9. 安装相关的库 yum install net-tools
10. yum -remove mysql-libs
11. yum install perl-Module-Install.noarch
12. yum install perl
13. mysql8 要安装5个包 common lib plugin client server/ mysql5 不用plugin

14. 验证：mysqladmin --version
15. 初始化MYSQL mysqld --initialize --user=mysql
16. 查看密码： cat /var/log/mysqld.log
17. A temporary password is generated for root@localhost: xI-gkdhUr7ia
18. systemct start mysqld
19. systemctl list-unit-files |grep mysqld.service
20. systemctl enable mysqld.service

3、启动mysql服务
1. mysql -uroot -p 回车 输入密码
2. alter user ‘root’@‘localhost’ identified by ‘ABCabc123.’

4、关闭本机防火墙
1. windows
2. centos
1. systemctl status firewalld
2. 关闭防火墙systemctl disable firewalld
3. 开放端口
1. firewall-cmd --list-all
2. firewall-cmd --add-service=http --permanent
3. firewall-cmd --add-port=3306/tcp --permanent
4. firewall-cmd --reload

5、mysql5.7 设置字符集
1. vi /etc/my.cnf
2. 服务级别 character_set_server=uft8
3. 数据库级别 character_set_database=utf8

6、mysql8.0链接还需要在数据库中执行
alter user ‘root’@‘%’ identified with mysql_native_password by ‘密码(ABCabc123.)’;