当前位置: 首页 > Linux

Centos7下安装mysql8

时间:2023-04-07 00:13:57 Linux

下载(速度慢的可以去清华镜像下载)上传到服务器(数据库服务器一般无法连接外网,需要这样安装)解压高版本tar[root@localhost~]#tar-zxvfmysql-8.0.17-linux-glibc2.12-x86_64.tar.xz[root@localhost~]#mv/usr/local/mysql-8.0.17-linux-glibc2.12-x86_64//usr/local/mysql低版本tar[root@localhost~]#xz-dmysql-8.0.17-linux-glibc2.12-x86_64.tar.xz[root@localhost~]#tarxvfmysql-8.0.17-linux-glibc2.12-x86_64.tar-C/usr/local/[root@localhost~]#mv/usr/local/mysql-8.0.17-linux-glibc2.12-x86_64//usr/local/mysql添加用户并附加权限[root@localhost~]#useraddmysql[root@localhost~]#chown-Rmysql.mysql/usr/local/mysql/initialization(注意控制台输出的账号密码hrKXDyFs?9#N)[root@localhost~]#/usr/local/mysql/bin/mysqld--initialize--user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/数据配置[root@localhost~]#mkdir/usr/local/mysql/logs[root@localhost~]#touch/usr/local/mysql/logs/log.err[root@localhost~]#touch/usr/local/mysql/data/localhost.localdomain.pid[root@localhost~]#chown-Rmysql.mysql/usr/local/mysql/[root@localhost~]#vi/etc/my.cnf#修改[client]socket=/usr/local/mysql/mysql.sockdefault-character-set=utf8mb4[mysqld]datadir=/usr/local/mysql/datasocket=/usr/local/mysql/mysql.socksymbolic-links=0sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'max_connections=800character-set-server=utf8mb4collat??ion-server=utf8mb4_general_mysql-default-authentative[]-error=/usr/local/mysql/logs/log.errpid-file=/usr/local/mysql/data/localhost.localdomain.pid!includedir/etc/my.cnf.d[root@localhost~]#vi/etc/profile#添加环境变量exportPATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib#使配置生效[root@localhost~]#source/etc/profilestartup设置[root@localhost~]#cp/usr/local/mysql/support-files/mysql.server/etc/init.d/mysql[root@localhost~]#chkconfig--add/usr/local/mysql/support-files/mysqlstart[root@localhost~]#systemctlstartmysqlloginmysql-uroot-phrKXDyFs?9#N修改密码进入执行其他操作alteruser'root'@'localhost'identifiedby'wangBin_123'