Centos8安装Mysql8.0小白教程

目录

1：先卸载自带的mariadb

2：下载和安装mysql源

3：如果报错：

4：启动Mysql服务

5：设置开机启动

6：查看默认生成密码

7：登录mysql

8：设置远程访问

9：即可用远程连接工具连接

10：关闭严格模式

---

1：先卸载自带的mariadb

yum remove mariadb-libs.x86_64

2：下载和安装mysql源

如果没有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
yum -y install mysql-community-server

3：如果报错：

No match for argument: mysql-community-server
Error: Unable to find a match: mysql-community-server
执行以下命令：
yum module disable mysql
或
sudo yum install mysql-server --nogpgcheck



Public key for mysql-community-common-8.0.33-1.el7.x86_64.rpm is not installed
 Failing package is: mysql-community-common-8.0.33-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
执行以下命令：
sudo rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*

更新yum：
yum clean all | yum makecache

4：启动Mysql服务

systemctl start mysqld

5：设置开机启动

systemctl enable mysqld
systemctl daemon-reload

6：查看默认生成密码

到该路径下找日志：
/var/log/mysqld.log

上面就是默认登录密码

7：登录mysql

mysql -u root -p
输入默认密码登录
登录后需要先修改默认密码：
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

8：设置远程访问

切换数据库：
use mysql;
修改连接名：
update user set host = '%' where user = 'root';
执行完后刷新立即生效：
FLUSH PRIVILEGES;

9：即可用远程连接工具连接

10：关闭严格模式

修改etc下my.cnf 文件

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

重启mysql

添加子用户：

CREATE USER '用户名'@'%' IDENTIFIED WITH mysql_native_password BY '密码';

GRANT Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create View, Delete, Drop, Event, Execute, Grant Option, Index, Insert, Lock Tables, References, Select, Show View, Trigger, Update ON `表名`.* TO `用户名`@`%`;