关于Fedora29下手动安装MySQL80及解决error 1146 (42S02):mysql.role_edges表不存问题,最终顺利修改root密码(密码修改可以不遵守新的密码要求策略)
问题如下:
ERROR 1146 (42S02): Table ‘mysql.role_edges’ doesn’t exist
手动下载MySQL80rpm包及安装过程:
[root@localhost Downloads]# ls
mysql-community-client-8.0.15-1.fc29.x86_64.rpm
mysql-community-common-8.0.15-1.fc29.x86_64.rpm
mysql-community-libs-8.0.15-1.fc29.x86_64.rpm
mysql-community-server-8.0.15-1.fc29.x86_64.rpm
[root@localhost Downloads]# rpm -i mysql-community-server-8.0.15-1.fc29.x86_64.rpm
package mysql-community-server-8.0.15-1.fc29.x86_64 is already installed
[root@localhost Downloads]# rpm -U mysql-community-client-8.0.15-1.fc29.x86_64.rpm
package mysql-community-client-8.0.15-1.fc29.x86_64 is already installed
[root@localhost Downloads]# rpm -U mysql-community-libs-8.0.15-1.fc29.x86_64.rpm
package mysql-community-libs-8.0.15-1.fc29.x86_64 is already installed
[root@localhost Downloads]# rpm -U mysql-community-common-8.0.15-1.fc29.x86_64.rpm
package mysql-community-common-8.0.15-1.fc29.x86_64 is already installed
打开安装日志,获取安装后系统分配的临时密码(例如:Pa_UFkCq<467):
[root@localhost Downloads]# sudo grep ‘temporary password’ /var/log/mysqld.log
2019-02-18T03:04:08.835667Z 1 [Note] A temporary password is generated for root@localhost: Pa_UFkCq<467
启动MySQL服务及查看服务状态: