maria-discuss team mailing list archive

[Brian Evans <grknight@xxxxxxxxxxxxxx>]

On 6/6/2017 3:43 PM, Timothy D. Legg wrote:
> Hello,
>
> First of all, here is what I'm working with:
>
> Original machine: MySQL Server 5.7.18-0ubuntu0.16.04.1
> Destination machine: MariaDB 10.0.30-MariaDB-0+deb8u2
>
> These two machines have no filesystem or communication with with other.
>
> I am moving to MariaDB with about 10 to 15 databases that were created in
> MySQL and I have had a very odd problem with the destination machine
> running MariaDB where the applications using these databases were having
> connection errors with their databases.
>
> I looked very carefully at what I had done.  I exported the databases from
> MySQL using:
>
> $ mysqldump --all-databases > all.sql

This is your problem.  You are overwriting the system tables with values
which will not work in MariaDB 10.0.30.

MySQL 5.7 permissions are, supposedly (I haven't tested), compatible
with MariaDB 10.2, but not 10.0.

In that all.sql file, remove any CREATE, DROP or ALTER statements to the
mysql system database (which is the permissions system).
Alternatively, do not dump the mysql system database and create those
permissions by hand before the import using CREATE USER and/or GRANT
statements.

Brian