Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails

[Rick James]

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`.