Installation of various versions of MySQL 8.0.18 and problems encountered during installation (essence summary)

rpm -qa | grep mysql

rpm -e mysql //Normal deletion mode rpm -e --nodeps mysql //Forced deletion mode. If you are prompted to delete other dependent files when using the above command, you can use this command to forcefully delete them rpm -ivh mysql-community-common-8.0.11-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-8.0.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-8.0.11-1.el6.x86_64.rpm

mysql -V

service mysqld start

flush privileges
alter user root@'localhost' identified by 'root';
service mysqld restart

iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

show variables like '%pass%';

drop user root@'localhost'
create user root@'localhost' identified by 'root';
rant all on . to root@'localhost' with grant option;

mysql -uroot -p -h192.168.1.193
select user,host,plugin from mysql.user;

service mysqld restart

mysql> drop user leo;
Query OK, 0 rows affected (0.10 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> create user leo identified by 'mysql';
Query OK, 0 rows affected (0.02 sec)
mysql> grant all on . to leo;
Query OK, 0 rows affected (0.08 sec)

show variables like 'character%';

/etc/rc.d/init.d/mysqld -stop

rpm -qa | grep mariadb

rpm -e mariadb-libs-5.5.35-3.el7.x86_64 --nodeps

rpm -ivh mysql-community-common-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm

rpm -qa | grep mysql
chmod -R 777 /var/lib/mysql

lower_case_table_names=1
character-set-server=utf8

mysqld --initialize

chmod -R 777 /var/lib/mysql

systemctl start mysqld to start the mysql service systemctl status mysqld to view the mysql status cat /var/log/mysqld.log | grep password to view the root initial password mysql -u root -p #After pressing Enter, enter the previous initial password, which is Iv7fjuP,ucH+ (fill in your own password)
ALTER USER "root"@"localhost" IDENTIFIED BY "root";
FLUSH PRIVILEGES; #Effective immediatelyuse mysql;
update user set host = '%' where user = 'root';
ALTER USER 'root'@'%' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER; #Change the encryption method ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root'; #Update the user password (here I am using root)
Book

xz -d mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz
tar -xvf mysql-8.0.18-linux-glibc2.12-x86_64.tar
apt-get install lib32stdc++6
For Red Hat:
sudo yum install libstdc++.i686
sudo yum install libstdc+±devel.i686
mkdir data
groupadd mysql
useradd -g mysql mysql
chown -R mysql.mysql /home/mysql/

chown -R mysql .
chgrp -R mysql .
mkdir -p /home/mysql/data
/home/mysql/bin/mysqld --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize //Initialize the database

twi=Tlsi<0O!
yum install libnuma
yum -y install numactl
yum install libaio1 libaio-dev
cp /home/mysql/support-files/mysql.server /etc/init.d/mysqld
vim /etc/my.cnf
[mysqld]
basedir = /home/mysql
datadir = /home/mysql/data
socket = /home/mysql/mysql.sock
character-set-server=utf8
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
socket = /home/mysql/mysql.sock
default-character-set=utf8
chmod +x /etc/init.d/mysql
chkconfig --add mysql
chkconfig --list mysqld
vim /etc/profile

export PATH=$PATH:/home/mysql/bin:/home/mysql/lib
export PATH

source /etc/profile
service mysql start
cat /root/.mysql_secret
mysql -uroot -p password SET PASSWORD FOR 'root'@localhost=PASSWORD('123456'); #Replace it with your own password.
use mysql
update user set host='%' where user='root' limit 1;
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';