本文共 945 字,大约阅读时间需要 3 分钟。
估计是手欠,一不小心把mysql5.7升到8.0.15,版本高看着就爽啊。
结果是mysql起不起来了。。。于是想了各种办法:
[ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
然后在google上搜“[ERROR] [MY-013129] [Server]”,原来已经有人遇到同样的问题了:
1. stop 5.7.212. swap binaries for 8.0.43. start mysql with skip-networking and skip-grant-tables etc.4. sudo mysql_upgrade --no-defaults $(sudo my_print_defaults client | egrep '^--socket' | head -1)5. restart mysql
依样画葫芦:
1.brew services stop mysql2.mysqld_safe --user=mysql --skip-grant-tables --skip-networking &3.sudo mysql_upgrade --no-defaults $(sudo my_print_defaults client | egrep '^--socket' | head -1)4.brew services start mysql
问题解决
转载于:https://blog.51cto.com/ustb80/2384166