Web lists-archives.com

Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today






Am 23.02.2018 um 15:15 schrieb Bob Eby:
2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.

How do I run mysql_upgrade if the mysqld server won't start?

post the *full* errorlog and watch for invaluid config stuff

most likely start mysqld without grant-tables (CAUTION: every user with and without password works for that time from everywhere!) would break the loop so that "mysql_upgrade" suceeds and after that *mmedidiatly* start the sevrer again with permission system enabled

https://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables

https://ma.ttias.be/mysql-table-mysql-plugin-doesnt-exist-after-mysql-upgrade/




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql