Centos安装Mysql 8.0 详细教程

yum install lrzsz -y
rz

cp mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz /usr/local
cd /usr/local/
tar -xvf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
tar -zxvf mysql-8.0.20-linux-glibc2.12-x86_64.tar.gz
mv mysql-8.0.20-linux-glibc2.12-x86_64 mysql

du -h --max-depth=1

groupadd mysql
useradd mysql -g mysql

mkdir data
chown mysql:mysql data

##初始化数据目录
[root@old mysql]# bin/mysqld --initialize --user=mysql --datadir /usr/local/mysql/data

#bin/mysqld_safe --datadir=/usr/local/mysql/data --user=mysql & 		##启动MySQL服务
#cp support-files/mysql.server /etc/init.d/mysql.server 		##将MySQL加入到服务自启动

##将默认启动文件复制到指定目录
[root@old support-files]# cp mysql.server /etc/init.d/
#需要判断当前镜像是否安装的有mariadb执行卸载
rpm -e --nodeps  mariadb-libs
rm -rf /etc/my.cnf
##通过服务启动MySQL
/etc/init.d/mysql.server start
/etc/init.d/mysql.server stop

ps -ef|grep mysql

netstat -an|grep LISTEN

vim .bash_profile

PATH=$PATH:$HOME/bin:/usr/local/mysql/bin

source .bash_profile

mysql -u root -p

5.7
set password=password('mysql');
8.0版本需要这种方式更新用户密码
alter user user() identified by 'mysql';

启动过程中如果碰到如下错误
[root@localhost mysql]# bin/mysqld --initialize --user=mysql --datadir /usr/local/mysql/data
bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
则需要安装包
yum install -y libaio

/etc/init.d/mysql.server stop

[root@old ~]# mkdir /data
[root@old ~]# cd /data
[root@old data]# mkdir mysql
[root@old data]# cd mysql
[root@old mysql]# mv /usr/local/mysql/data .

vim /etc/my.cnf

[mysqld]
datadir=/root/data/mysql/data

/etc/init.d/mysql.server start

#不使用推荐安装路径的方法
bin/mysqld --initialize --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data &
bin/mysqld_safe --basedir=/data/mysql --datadir=/data/mysql/data --user=mysql &

cp /etc/my.cnf /etc/my3307.cnf

[mysqld]
basedir=/data/mysql/mysql
datadir=/data/mysql/mysql/data
port=3307
socket=/tmp/mysql3307.sock
mysqlx_port=33070
mysqlx_socket=/tmp/mysqlx33070.sock

bin/mysqld --defaults-file=/etc/my3307.cnf --user=mysql &
#如何关闭呢

cd /tmp
[root@old ~]# mysql -u root -p -S /tmp/mysql3307.sock