【文件属性】：
文件名称：linux安装mysql(rpm脱网安装).zip
文件大小：195.31MB
文件格式：ZIP
更新时间：2022-10-31 03:19:34
linux mysql安装 rpm方式安装mysql mysql脱网安装
1、把以下5个rpm上传到/home/soft/mysql目录
2、执行rpm安装
#rpm -ivh mysql-*.rpm --force --nodeps
3、安装完成后执行以下命令查询mysql root帐号密码
#grep 'temporary password' /var/log/mysqld.log
没拿到，执行以下命令后，再执行上面命令查
rm -rf /var/lib/mysql
systemctl restart mysqld
如出现以下错误
TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server op
解决方法：在 vi /etc/my.cnf 文件中加上 ： explicit_defaults_for_timestamp=true 。保存后再次启动就可以了。
loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
原因是没有安装libaio.so.1，安装即可。
Redhat/Fedora/CentOS下执行：
yum install libaio
4、修改root密码及允许远程访问
输以下命令回车并输入密码登录mysql
#mysql -uroot -p
通过sql更新密码及远程访问权限
mysql> use mysql;
mysql> update user set password=password('123456') where user='root';
mysql> update user set host = '%' where user = 'root';
mysql> flush privileges;
错误解决：
You must reset your password using ALTER USER statement before executing this statement.
alter user user() identified by "123456";
Your password does not satisfy the current policy requirements
set global validate_password_policy=LOW;
set global validate_password_length=6;
【文件预览】：
mysql-community-server-5.7.25-1.el7.x86_64.rpm
mysql-community-devel-5.7.25-1.el7.x86_64.rpm
mysql-community-common-5.7.25-1.el7.x86_64.rpm
mysql-community-libs-5.7.25-1.el7.x86_64.rpm
mysql-community-client-5.7.25-1.el7.x86_64.rpm