centos 8/9 安装mysql

#centos8
wget http://repo.mysql.com/mysql80-community-release-el8-1.noarch.rpm

rpm -ivh mysql80-community-release-el8-1.noarch.rpm
yum install mysql-server

mkdir /data/

vi /etc/my.cnf.d/mysql-server.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysql/mysqld.log
pid-file=/run/mysqld/mysqld.pid

改成
[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
log-error=/var/log/mysql/mysqld.log
pid-file=/run/mysqld/mysqld.pid

wq 保存退出

mv /var/lib/mysql /data/


systemctl start mysqld

systemctl enable mysqld
Created symlink /etc/systemd/system/multi-user.target.wants/mysqld.service → /usr/lib/systemd/system/mysqld.service.


vi /etc/my.cnf.d/client.cnf
加入
[mysql]
socket=/data/mysql/mysql.sock








---------------------------------
#centos9
wget https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm
rpm -ivh mysql80-community-release-el9-1.noarch.rpm
yum install mysql-server

systemctl start mysqld.service
systemctl enable mysqld.service
mysql_secure_installation

show variables like 'validate_password%';
set global validate_password.policy =LOW;

mkdir /data/

#密码在这里
cat /var/log/mysqld.log 






mysql -u root -p
create database test;
create user 'wang'@'localhost' identified by 'password';
grant all privileges on *.* to 'wang'@'localhost' with grant option; 
select user,host,grant_priv from user ;
update user set host='%' where user='wang'
alter user wang identified by 'password2';
flush privileges;