mysql-8.0.27-linux版本安装手册，让你一路畅通无阻，2分钟就完成安装

cat /etc/redhat-release

ldd --version

cd /usr/local

tar -xvf mysql-8.0.27-linux-glibc2.17-x86_64-minimal.tar.xz

mv mysql-8.0.27-linux-glibc2.17-x86_64-minimal mysql-8.0.27

touch /etc/my.cnf

vim /etc/my.cnf

[mysqld]
port=3306
basedir=/usr/local/mysql-8.0.27
datadir=/usr/local/mysql-8.0.27/data
socket=/usr/local/mysql-8.0.27/data/mysql.sock

character-set-server=utf8
collation-server=utf8_general_ci
#performance_schema_max_table_instances=400
#table_definition_cache=400
#table_open_cache=256
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
# 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
max_allowed_packet=1024M
max_connections=1000
# Recommended in standard MySQL setup
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
wait_timeout=2147483
interactive_timeout=2147483
connect_timeout=20
thread_cache_size=256
lower_case_table_names=1
innodb_strict_mode=0
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
innodb_file_per_table=1
log_bin_trust_function_creators=1
[mysqld_safe]
log-error=/usr/local/mysql-8.0.27/log/mysqld.log
pid-file=/usr/local/mysql-8.0.27/log/mysqld.pid
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
[client]
default-character-set=utf8
socket=/usr/local/mysql-8.0.27/data/mysql.sock
#
# include all files from the config directory
#
#!includedir /etc/my.cnf.d

mkdir data

mkdir log

echo "" > /usr/local/mysql-8.0.27/log/mysqld.log

 ./bin/mysqld --initialize --user=root --basedir=/usr/local/mysql-8.0.27 --datadir=/usr/local/mysql-8.0.27/data

yum -y install libaio.so.1

yum -y install numactl

cd /usr/local/mysql-8.0.27/rpm
rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm

cd /usr/local/mysql-8.0.27

 ./bin/mysqld --initialize --user=root --basedir=/usr/local/mysql-8.0.27 --datadir=/usr/local/mysql-8.0.27/data

cd /usr/local/mysql-8.0.27

vim ./support-files/mysql.server

basedir=/usr/local/mysql-8.0.27
datadir=/usr/local/mysql-8.0.27/data

cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld

chmod +x /etc/rc.d/init.d/mysqld

chkconfig --add mysqld

chkconfig --list mysqld

service mysqld start

vim /etc/rc.d/init.d/mysqld

vim /etc/rc.d/init.d/mysqld

service mysqld start

vim /etc/profile

MYSQL_HOME=/usr/local/mysql-8.0.27
export PATH=$PATH:$MYSQL_HOME/bin

source /etc/profile

mysql -uroot -p

alter user 'root'@'localhost' identified by '321qwe!@#';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

use mysql

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

grant all on *.* to 'root'@'%' with grant option;

exit

vi /etc/sysconfig/iptables

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

service iptables restart