文件名称：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