centos7.6安装mysql8配置远程连接

四种安装方式：

1、yum或apt
2、rpm包或deb包
3、源代码编译安装
4、generic-linux安装（编译完成mysql，解压缩后配置即可运行）

实验环境：

centos7.6
mysql 8.0.20

---

pre-install 检查：
1、检查libaio

rpm -qa | grep libaio

2、检查mysql是否已经安装

rpm -qa | grep mysql

netstat -tunlp | grep 3306

ps -ef | grep mysql

3、如果已经mysql或者已经打开MySQL服务器

systemctl stop mysqld.service

yum remove mysql

yum remove mariadb

---

单数据库主机

1、上传压缩包

2、解压缩
tar -Jxvf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

mv mysql-8.0.20-linux-glibc2.12-x86_64 /usr/local/mysql

3、检查libaio包是否已安装

rpm -qa | grep libaio

4、创建mysql用户

useradd -s /sbin/nologin -r -M mysql

5、修改mysql目录属主、属组并修改文件夹名称

chown mysql:mysql /usr/local/mysql

6、初始化数据库，注意初始化数据库时生成的临时密码
mysqld --user=mysql --initialize --explicit_defaults_for_timestamp

A temporary password is generated for root@localhost: !FS4p1tdkXVN

7、配置mysql主配置文件

vim /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql/
socket=/var/lib/mysql/mysql.sock

symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysql.log
pid-file=/var/lib/mysql.pid

!includedir /etc/my.cnf.d

[client]
socket=/var/lib/mysql/mysql.sock

修改/var/目录下log文件夹权限

chmod -R 777 /var/log/
chmod -R 777 /var/lib/

建立目录/etc/my.cnf.d/

mkdir /etc/my.cnf.d

8、修改root环境变量 和 /etc/ld.so.conf文件

vim ~/.bash_profile

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

vim /etc/ld.so.conf 末尾添加以下内容

/usr/local/mysql/lib

运行ldconfig命令

10、启动数据库

/usr/local/mysql/support-files/mysql.server start

11、连接数据库并测试

/usr/local/mysql/bin/mysql -uroot -p
连接数据库出错

报错1：./mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

输入命令：ln -s  /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5

12、修改root用户密码，root用户使用临时密码登录mysql后，执行以下命令

mysql> alter user root@localhost identified by ‘123456’;
mysql> flush privileges;

13、配置远程连接
mysql> update user set host = ‘%’ where user =‘root’;
mysql> flush privileges;
mysql> alter user ‘root’@’%’ identified with mysql_native_password by ‘123456’;