I was afraid of that, but I was too tired to experiment along those lines, else I could have screwed up in a spectacular way.
I examined the 900+ lines of mysql.sql and found all the ALTER strings were commented in C-style, but removing the CREATEs would have eliminated some of the key purposes of the file's existence. I decided to manually repopulate the user table. I successfully granted the permissions to the respective users (except one that will require a string copy of mysql.user.authentication_string since I'm not certain anymore of the locations of that particular password in the configuration files (possibly in two locations). Things have been mostly sorted out and I greatly appreciate the help. I still have a problem to sort out, but it is distinct enough that it warrants a separate thread. Thank you very much! Timothy D. Legg > 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 > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
