Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
Posted by:
Rick James
Date: November 11, 2014 12:22PM
Hmmm...
Suggestion...
1. Blow away the 5.6.
2. Reinstall 5.6. -- mysql_upgrade is _not_ needed since there is no old data to fix.
3. Add the new user. -- Note that this is before reloading the dump.
4. Verify that the new user 'works'. You might play around with
CREATE DATABASE `db_account_transaction` DEFAULT CHARACTER SET;
since it won't interfere with the reload.
5. Reload the old 5.1 data.
6. Test...
If the new user is broken in step 6, then I wonder (again) if the dump messed with the `mysql` database.
There _may_ be datatype changes between 5.1.2 (very early in 5.1) to 5.6.19 (reasonably current). We'll look into that if you can find any specifics. Do you use BIT, DECIMAL, or PARTITION BY KEY? (Seems like those had changes in the given timeframe.) The load from the dump _should_ avoid any such issues.
In any case, look at the mysqld.err file for possible clues of trouble.
Subject
Written By
Posted
November 07, 2014 10:37AM
November 08, 2014 10:07AM
November 08, 2014 02:05PM
November 09, 2014 02:10PM
November 10, 2014 05:11AM
Re: MySQL 5.6: creating users kills mysql, and mysq_upgrade fails
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.