转自linux 安装mysql8.0 超详细图文教程_linux mysql8 下载安装-CSDN博客

1、下载mysql安装包

2、切换到安装目录下

3、解压mysql

tar xvJf mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz

4、重命名mysql文件夹

mv mysql-8.0.26-linux-glibc2.12-x86_64 mysql8.0

5、进入mysql8.0文件夹，新建data文件夹

cd mysql8.0/
    
mkdir data

6、创建用户组及用户密码

groupadd mysql
    
useradd -g mysql mysql

7、授权用户

chown -R mysql.mysql /home/mysql/mysql8.0

8、编辑my.cnf文件

vi /etc/my.cnf
[mysqld]
basedir=/home/mysql/mysql8.0/
datadir=/home/mysql/mysql8.0/data/
character-set-server=UTF8MB4
socket=/tmp/mysql.sock
lower_case_table_names=1  #这里是设置大小写不敏感
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

#[mysqld_safe]
#log-error=/var/log/mariadb/mariadb.log
#pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#

9、初始化，获取初始密码

cd /home/mysql/mysql8.0/bin

./mysqld --user=mysql --basedir=/home/mysql/mysql8.0  --datadir=/home/mysql/mysql8.0/data/ --initialize --lower-case-table-names=1

10、返回安装目录，添加mysqld服务到系统，授权以及添加服务

cd /home/mysql/mysql8.0

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

chmod +x /etc/init.d/mysql
 
chkconfig --add mysql

11、启动mysql

service mysql start

12、将mysql命令添加到服务

ln -s /home/mysql/mysql8.0/bin/mysql /usr/bin

13、使用初始密码登录mysql

mysql -uroot -p

14、设置新密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'sumling@123';#sumling@123为新密码

flush privileges;   #重新加载是密码生效

15、修改远程连接

use mysql;

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

至此安装结束