新总结的linux版mysql8

sudo tar -xvf mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz -C /usr/local
 cd /usr/local
 mv mysql-8.0.25-linux-glibc2.12-x86_64/ mysql
 sudo mkdir data
 vim /etc/my.cnf
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ --initialize

cd /usr/local/mysql/support-files/
cp ./mysql.server /etc/init.d/mysql
chmod 755 /etc/init.d/mysql
sudo chkconfig --level 345 mysql on
cd /usr/local/mysql/data/
touch master.pid

etc/ld.so.conf要配置路径，不然报错 

1. # vim /etc/ld.so.conf

2. 添加如下内容:

3. /usr/local/mysql/lib

配置环境变量

1. # vim /etc/profile

2. # source /etc/profile

3. 添加如下内容：

4. #MYSQL ENVIRONMENT

5. export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib

sudo service mysql restart

mysql -uroot -p 
alter user user() identified by "root";
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
select user,host,authentication_string from mysql.user;
  
create user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
grant all privileges on *.* to 'root'@'%';
flush privileges;

=====================================================

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

sudo find / -name mysql.sock
chown -R mysql:mysql ./mysql.sock
启动方式：两种都可以
/etc/init.d/mysqld status
sudo service mysql start