资源说明: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;
本源码包内暂不包含可直接显示的源代码文件,请下载源码包。
English
