OpenEuler20.03安装mysql8.0.19

一、准备工作

1、dnf update 更新源 rpm安装包时用

2、tar 安装 tar --help 查看是否存在

如果没有 yum install tar

3、版本下载 mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz    https://downloads.mysql.com/archives/community/

二、安装

1、上传到 /usr/local下

tar -Jxvf mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz 

如果是gz格式  tar -zxvf mysql-8.0.19-linux-glibc2.12-x86_64.tar.gz

2、重命名 mv mysql-8.0.19-linux-glibc2.12-x86_64 mysql8

3、建立数据存放文件目录 cd mysql8    =>    mkdir data 建立完毕 如果是别的地方 请建立后把地址记录好

4、建立组和用户  groupadd mysql && useradd -r -g mysql mysql  

注意 mysql8 文件夹里建立

5、授权文件夹  chown -R mysql.mysql /usr/local/mysql8

6、初始化 cd bin   /usr/local/mysql8/bin 目录下执行

./mysqld --user=mysql --basedir=/usr/local/mysql8 --datadir=/usr/local/mysql8/data/ --initialize

会生成一个密码 一定要复制到文本中记录好 修改密码时用到

7、编辑或创建 vi /etc/my.cnf 

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[client]
port=3306
default-character-set=UTF8MB4
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
basedir=/usr/local/mysql8/
datadir=/usr/local/mysql8/data
socket=/tmp/mysql.sock
character-set-server=UTF8MB4
#skip-grant-tables

[mysqld_safe]
log-error=/var/log/mysqld.log

8、添加服务到系统

cp -a ./support-files/mysql.server /etc/init.d/mysql

9、授权和添加服务

chmod +x /etc/init.d/mysql

chkconfig --add mysql

10、启动mysql

service mysql start

查看状态 service mysql status

11、把mysql添加到服务

ln -s /usr/local/mysql8/bin/mysql /usr/bin

12、登录和修改密码

mysql mysql -uroot -p 输入6步生成的临时密码

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1qaz2wsx';

执行 flush privileges; 使密码生效

use mysql;

update user set host='%' where user='root';  使root能远程登录

执行 flush privileges; 使远程登录生效

quit 登出 

firewall-cmd --permanent --add-port=3306/tcp

firewall-cmd --reload

可以远程访问一下 或systemctl reboot一下 看mysql服务是否注册正常