去官网下载离线安装包mysql-8.0.30-1.el7.x86_64.rpm-bundle.tar
上传并解压:
tar -vxf mysql-8.0.30-1.el7.x86_64.rpm-bundle.tar -C /data/install/mysql
创建mysql用户:
useradd -d /home/mysql mysql
groupadd mysql
usermod -g mysql mysql
passwd mysql
进入到mysql目录,执行安装命令:
sudo rpm -ivh *.rpm --nodeps --force
创建mysql安装目录:
mkdir /data/server/mysql
sudo chown -R mysql:mysql /data/server/mysql
sudo chmod -R 755 /data/server/mysql
修改 my.conf
:
vim /etc/my.conf
lower-case-table-names=1
datadir=/data/server/mysql
执行初始化:
sudo mysqld --initialize --user=mysql
找到初始密码:
sudo cat /var/log/mysqld.log
[Server] A temporary password is generated for root@localhost: gpC37_l!K#GJ
启动mysql:
sudo systemctl start mysqld
修改默认密码:
mysql -uroot -p
alter user 'root'@'localhost' identified by '12gpC37_l!K#GJ56';
flush privileges;
修改远程登录:
update user set host='%' where host='localhost';
flush privileges;