MySQL之Linux环境安装

https://dev.mysql.com/downloads/mysql/

解压
tar -xvf mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz


重命名
mv mysql-8.0.28-linux-glibc2.12-x86_64 mysql-8.0.28

创建数据目录
mkdir data

创建mysql用户组以及用户权限
groupadd mysql
useradd -r -g mysql mysql
chown mysql:mysql -R /usr/local/mysql/

vim /etc/my.cnf

[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql

basedir=/usr/local/mysql/mysql-8.0.28
datadir=/data
socket=/tmp/mysql.sock

log-error=/usr/local/mysql/mysql-8.0.28/data/mysql.log
pid-file=/usr/local/mysql/mysql-8.0.28/data/mysql.pid

character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true

# include all files from the config directory
!includedir /etc/my.cnf.d

初始化
./bin/mysqld --initialize --console --user=mysql
查看初始登录密码
cat data/mysql.log

添加mysql服务
cp /usr/local/mysql/mysql-8.0.28/support-files/mysql.server /etc/init.d/mysql
启动
service mysql start

登录客户端
./bin/mysql -u root -p

修改登录密码

# 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
# 密码加密，以防navicat客户端工具连接时报2059错误
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
# 刷新
FLUSH PRIVILEGES; 

use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;

关闭服务
service mysql stop
以无授权方式启动
./bin/mysqld --skip-grant-tables &

./bin/mysql -u root -p
启动后，回车不需要密码
依次执行以下命令

use mysql;
FLUSH PRIVILEGES;
select user,host from user;
ALTER USER 'root'@'%' IDENTIFIED BY '1234' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '1234';
FLUSH PRIVILEGES;