MySQL 8.0安装

yum search libaio
yum install -y libaio

rpm -qa|grep -i mariadb*
yum remove -y mariadb*

groupadd mysql
useradd -r -g mysql -s /bin/false mysql

cd /mysql_dir/
tar xvf mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz
ln -s mysql-8.0.23-linux-glibc2.12-x86_64 mysql
cd ..
mkdir data
chown mysql:mysql data
chmod 750 data

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/mysql_dir/mysq8/mysql/bin ===>修改

export PATH

cd /mysql_dir/mysql
vi /etc/my.cnf

[mysqld]
server-id=8
datadir=/mysql_dir/data
socket=/tmp/mysql.sock
user=mysql
log-bin=/mysql_dir/data/mysql-bin.log
log-bin-index=/mysql_dir/data/mysql-bin.index

[mysqld_safe]
log-error=/mysql_dir/data/mysqld.log
pid-file=/mysql_dir/data/mysqld.pid

[mysql]
prompt="\\u@\\h:\\p [\\d]>"

mysqld --initialize --user=mysql

mysqld_safe --user=mysql &
alter user ‘root‘@‘localhost‘ identified by ‘mysql123‘;
mysql -uroot -pmysql123

[client]
host=localhost
user=root
password=mysql123