CentOS8.2使用脚本安装mysql8.0

1、删除之前安装的Mysql

1、查看MySQL服务运行状态：

service mysql status

2、查看mysql服务

ps -ef|grep mysql

3、关闭mysql服务

service mysql stop

4、查看mysql安装包存储位置

find/-namemysql

5、删除以上文件夹

rm -rf /etc/selinux/targeted/active/modules/100/mysql

6、再次查看是否删除

2、安装

2.1、上传资源

如图所示，将mysql8.0的linux压缩包以及安装脚本上传至指定目录西。

#!/bin/bashMYSQL_VERSION="mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz"DIR="/usr/local"yum-yinstallnumactl* libaiocd/usr/localif([-f/usr/local/$MYSQL_VERSION]);thentar-xvfmysql-8.0.31-linux-glibc2.12-x86_64.tar.xzmvmysql-8.0.31-linux-glibc2.12-x86_64 mysqlgroupaddmysqluseradd-r-gmysql mysqlcd/usr/local/mysqlmkdirdatachown-Rmysql:mysql /usr/local/mysqlcd/usr/local/mysql/support-filessleep2cat>>my_default.cnf<<EOF [client] socket=/tmp/mysql.sock [mysqld] sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES basedir = /usr/local/mysql datadir = /usr/local/mysql/data port = 3306 socket = /tmp/mysql.sock character-set-server=utf8 lower_case_table_names=1 log-error = /usr/local/mysql/data/mysqld.log pid-file = /usr/local/mysql/data/mysqld.pid EOFsleep3if([-f/etc/my.cnf]);thenmv/etc/my.cnf my.cnf.bakcpmy_default.cnf /etc/my.cnfelsecpmy_default.cnf /etc/my.cnfficd/usr/local/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/mysqldln-s/usr/local/mysql/bin/mysql /usr/bincd/usr/local/mysql/datasleep5READPASS=`cat/usr/local/mysql/data/mysqld.log|grep-o"root@localhost: .*"`echo-e"ROOT PASSWORD\033[31m${READPASS}\033[0m"echo"MySQL DATADIR:/usr/local/mysql"echo"MySQL LOGFILE:/usr/local/mysql/data"echo"MySQL service mysqld start|stop|status|restart"elseecho"MySQL source file does not exist, please check"exit0fi

2.2、给脚本赋予权限

chmod 777 -R MySQL_Install.sh

2.3、执行脚本，等待安装

./MySQL_Install.sh

2.4、安装成功，记住默认密码

2.5、启动mysql

1、第一次连接mysql，发现连接失败，这是因为mysql没有启动

2、查看mysql状态：发现没启动

service mysqld status

3、启动mysql

service mysqld start

2.6、修改数据库默认密码

使用数据库使用脚本安装成功后显示的密码登录。

mysql -uroot -p alter user 'root'@'localhost' identified by '你的新密码'; FLUSH PRIVILEGES;

2.7、开启远程访问权限

1、查看远程访问权限

root用户的localhost表示只允许本机访问，要实现远程连接，可以将用户的host改为%，表示允许任意主机访问，如果需要设置只允许特定ip访问，则应改为对应的ip。

2.修改root用户的host字段为%

update mysql.usersethost="%"whereuser="root";

selectuser,host from mysql.user;

3.刷新配置

flush privileges;

2.8、开发端口

开放3306端口在外部可以访问，前提是要防火墙处于打开状态

firewall-cmd--permanent--zone=public --add-port=3306/tcp

#查看防火墙状态 systemctl status firewalld.service #关闭防火墙 systemctl stop firewalld.service #开启防火墙 systemctl start firewalld.service

2.9、测试远程连接