New client computer, so I installed the latest MySql Workbench – version 6.3.6.  Turns out that the new version no longer works for me when exporting a remote database.  Here’s the error I’m seeing:

mysql-exporterror

It works just fine when exporting local databases, though.  And here’s what’s going on:

  • I’m currently working on a remote shared hosting plan.
  • Shared plans mean that super-users are not for paid clients because there is a security risk.
  • MySql Workbench 6.3.6 started adding a ‘select * from mysql.users’ command during an export.
  • The ‘mysql.users’ table is in the super-user area that cannot be seen by shared hosting clients.

So, one solution is to move to a completely dedicated server, which I’ve considered over the past year for more reason than this.

But the solution I went with was a bit quicker to implement and seemed completely plausible.  Simply put, I downloaded an earlier version of MySql Workbench from the official site.

I knew that version 6.0.8 worked for me previously, so I went with that again.  It’s very possible that one of the versions between 6.0.8 and 6.3.6 works as well, but it was not a big deal for me to find out – at least not yet.