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

1、删除之前安装的Mysql1、查看MySQL服务运行状态service mysql status2、查看mysql服务ps -ef|grep mysql3、关闭mysql服务service mysql stop4、查看mysql安装包存储位置find/-namemysql5、删除以上文件夹rm -rf /etc/selinux/targeted/active/modules/100/mysql6、再次查看是否删除2、安装2.1、上传资源如图所示将mysql8.0的linux压缩包以及安装脚本上传至指定目录西。#!/bin/bashMYSQL_VERSIONmysql-8.0.31-linux-glibc2.12-x86_64.tar.xzDIR/usr/localyum-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-filessleep2catmy_default.cnfEOF [client] socket/tmp/mysql.sock [mysqld] sql_modeNO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES basedir /usr/local/mysql datadir /usr/local/mysql/data port 3306 socket /tmp/mysql.sock character-set-serverutf8 lower_case_table_names1 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--usermysql--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/datasleep5READPASScat/usr/local/mysql/data/mysqld.log|grep-orootlocalhost: .*echo-eROOT PASSWORD\033[31m${READPASS}\033[0mechoMySQL DATADIR:/usr/local/mysqlechoMySQL LOGFILE:/usr/local/mysql/dataechoMySQL service mysqld start|stop|status|restartelseechoMySQL source file does not exist, please checkexit0fi2.2、给脚本赋予权限chmod 777 -R MySQL_Install.sh2.3、执行脚本等待安装./MySQL_Install.sh2.4、安装成功记住默认密码2.5、启动mysql1、第一次连接mysql发现连接失败这是因为mysql没有启动2、查看mysql状态发现没启动service mysqld status3、启动mysqlservice mysqld start2.6、修改数据库默认密码使用数据库使用脚本安装成功后显示的密码登录。mysql -uroot -p alter user rootlocalhost identified by 你的新密码; FLUSH PRIVILEGES;2.7、开启远程访问权限1、查看远程访问权限root用户的localhost表示只允许本机访问要实现远程连接可以将用户的host改为%表示允许任意主机访问如果需要设置只允许特定ip访问则应改为对应的ip。2.修改root用户的host字段为%update mysql.usersethost%whereuserroot;selectuser,host from mysql.user;3.刷新配置flush privileges;2.8、开发端口开放3306端口在外部可以访问前提是要防火墙处于打开状态firewall-cmd--permanent--zonepublic --add-port3306/tcp#查看防火墙状态 systemctl status firewalld.service #关闭防火墙 systemctl stop firewalld.service #开启防火墙 systemctl start firewalld.service2.9、测试远程连接