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`.
Subject
Written By
Posted
November 07, 2014 10:37AM
Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
November 08, 2014 10:07AM
November 08, 2014 02:05PM
November 09, 2014 02:10PM
November 10, 2014 05:11AM
November 11, 2014 12:22PM
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.