官网下载mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar
https://dev.mysql.com/downloads/mysql/5.7.html
里面有
安装时按顺序yum安装libs common client server(因为之间会有依赖性不按这个顺序会提示缺少什么)
如果安装提示有冲突可以rpm -e --nodeps卸载冲突的包(确认好是否没用再卸载)
安装完server之后mysqld服务就会注册到系统上去
权限修改
chown mysql:mysql -R /var/lib/mysql
然后初始化
mysqld --initialize --console
然后去/var/log/mysqld查看初始密码
启动mysql
systemctl start mysqld.service
修改初始密码
mysql> alter user root@localhost identified by 'test_password';
初始只能本地连接,只有localhost
mysql> select host,user from user; +-----------+---------------+ | host | user | +-----------+---------------+ | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | +-----------+---------------+
修改连接
mysql> update user set host='%' where user='root';