解压tar
mkdir /usr/software/mysql
cd /usr/software
mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar 放在了software文件夹下
tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar -C ./mysql/
删除mysql-libs包
yum remove mysql-libs
安装rpm包 要有顺序
rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
初始化数据库
为了保证数据库目录为与文件的所有者为 mysql 登陆用户,如果你是以 root 身份运行 mysql 服务,需要执行下面的命令初始化
mysqld --initialize --user=mysql
启动数据库服务
systemctl start mysqld.service
初次登录在日志中找初始密码
cat /var/log/mysqld.log | grep password
重置密码
- 登录
mysql -u root -p
回车输入刚才查到的密码
SET PASSWORD = PASSWORD("123456");
``
授权远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit
打开3306端口
firewall-cmd --list-ports
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
firewall-cmd --list-ports