centos 8 安装mysql 8.0

// 安装wget服务

yum -y install wget

//下载和安装mysql源

wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

// 安装mysql源

yum -y localinstall mysql80-community-release-el8-1.noarch.rpm

// 在线安装Mysql

yum install mysql-server

yum -y install mysql-community-server

上面如果失败就运行下面

先执行：yum module disable mysql

再执行：yum -y install mysql-community-server

 

 

// 配置默认编码为utf8

//修改/etc/my.cnf配置文件  此处一定要先配置(大小写不敏感) 如果启动后 就无法修改了.........

[mysqld]

lower_case_table_names=1

character_set_server=utf8

init_connect='SET NAMES utf8'

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

// 启动Mysql服务

systemctl start mysqld

// 设置开机启动

systemctl enable mysqld

systemctl daemon-reload

// 修改root本地登录密码

mysql -u root -p 直接密码空

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Xxxx';

//查看密码

/var/log/mysqld.log

// 设置允许远程登录和开启防火墙

select user,authentication_string,host from user;

update user set host = '%' where user = 'root';

 

// 刷新修改

FLUSH PRIVILEGES;

quit

 

//停止服务

systemctl stop mysqld

//重启服务

systemctl restart mysqld

//查看服务

systemctl status mysqld