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