I am getting

Exception message:

Exception type: MySqlException Access denied for user 'username'@'ip' to database 'mysql'

The credentials work on that server. I am using dBeaver to test the connection to confirm.

Is there a way to change the 'to database 'mysql'' to the database name I want to connect too? I think that is the issue.

There is no database named 'mysql' on that server.

It is required that the user you use to connect to the MySql db has access to the 'mysql' catalog and be able to select the data in it.

The reason is that that catalog contains the meta-data. The designer queries that catalog for Meta-data retrieval, e.g. which tables / views are located in your catalog. The meta-data retrieval is done through the provider's GetSchema() method, so the actual query is constructed by the ADO.NET provider (corelab/devart).

You just need SELECT access to the meta data tables.

Thanks. I was unable to do that due to the hosting situation. So I just made a local copy of the db to get around that issue.