Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
Posted by: Rick James
Date: November 08, 2014 10:07AM

Let's focus on this (at least to start with):

> import of an old legacy DB

Was it a dump taken with mysqldump?

If so, does the dump have "DROP DATABASE" and "CREATE DATABASE" statements? Does the dump include the `mysql` database? Did you reload the entire dump? Or did you somehow load just the legacy database? What version does the dump say? Is that the version from which you took the dump?

I bark up that tree because of this:

> Incorrect definition of table mysql.proc

which implies that the table mysql.proc changed from when it was created (possibly from reloading the dump) to what is desired by your current 5.6.19. Using mysql_upgrade _should_ have fixed that.

Back to the dump... If you reloaded `mysql` in the dump, consider whether this might fix the problem:
1. blow away mysql 5.6.19 and reinstall it. (Note: be sure that the data is gone, too.)
2. reload the dump, but be sure to avoid `mysql`.

Options: ReplyQuote

Written By
Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
November 08, 2014 10:07AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.