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 `用户名`@`%`;

11：自定义配置文件参考

datadir=/data/data/mysql
socket=/var/lib/mysql/mysql.sock
wait_timeout=600
interactive_timeout = 600
max_connections=5000
mysqlx_max_connections=5000
max_connect_errors=10000
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLE
default_authentication_plugin=mysql_native_password

log-error=/data/log/mysql/mysqld.log
general_log_file=/data/logs/mysql/general.log
pid-file=/var/run/mysqld/mysqld.pid
 

12：修改存储路径和日志路径

chown -R mysql:mysql /data/data/mysql/

chown -R mysql:mysql /data/log/mysql/