linux环境MySQL8.0安装

按照以下步骤，可成功。
可能需要libaio库，先安装
yum install libaio
下载
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz
解压
tar -xvf mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz
复制到/usr/local/mysql
mv mysql-8.0.18-linux-glibc2.12-x86_64 /usr/local/mysql
cd /usr/local/mysql
mkdir data
添加用户
 groupadd mysql
 useradd -g mysql mysql
 chown -R mysql.mysql /usr/local/mysql/
 mkdir mysql_install_db
 chmod 777 ./mysql_install_db
 /usr/local/mysql/bin/mysqld --initialize --user=mysql
 ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
 ##到此，会提示初始化密码，记录下来，等安装完成，第一次打开数据库需要
 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
 cp -a ./support-files/mysql.server /etc/init.d/mysqld
 chmod +x /etc/init.d/mysqld
 chkconfig --add mysqld
 chkconfig  --list mysqld
 到此安装完成，下面是配置

配置：

vi /etc/profile
打开文件后，在最后添加
	export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib
	export PATH
退出编辑。
source /etc/profile

/etc/my.cnf 配置, 直接复制进去即可。

[mysqld]
    basedir = /usr/local/mysql
    datadir = /usr/local/mysql/data
    socket = /usr/local/mysql/mysql.sock
    character-set-server=utf8
    port = 3306
   sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
 [client]
   socket = /usr/local/mysql/mysql.sock
   default-character-set=utf8
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

启动mysql

service mysql start
#返回
Redirecting to /bin/systemctl start mysql.service
#数据库启动成功

下面是数据库修改密码，外网访问，服务器需开放3306端口

mysql -uroot -p
#输入刚才记录的密码，按回车
#修改密码
alter user 'root'@'localhost'IDENTIFIED BY '123456';
#创建用户aa，密码为123456
create user aa identified by '123456';
GRANT ALL ON *.* TO 'aa'@'%' WITH GRANT OPTION;
Flush privileges;

use mysql
update user set host='%' where user ='root';  更新域属性，'%'表示允许外部访问：
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;

到此结束。连续装了三台服务器，记录下来，下次直接复制

# navicate连接时，2059错误。修改密码加密规则。
use mysql
alter user 'root'@'%' IDENTIFIED BY '123' password expire never;
alter user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';
FLUSH PRIVILEGES;