I'm trying to start a new project and connect to a MySql database. I enter in the server IP, user name and password, but there is no where to enter the database name I want to connect to. It keeps failing trying to connect to the database named "mysql", but I don't have a database named mysql... How can I get this connected?
How can I enter in the database name I'm trying to connect to?
Exception type: MySqlException
Access denied for user 'username'@'xxx.xx.xx.xxx' to database 'mysql'
If that were true it wouldn't be failing my connection saying it can't access the database "mysql". I can connect to the database using MySqlWorkbench from the same machine using the same IP, Username and Password as well as from another Visual Studio project. I just can't login with LLBLGen...
I'm surprised it doesn't let you specify a specific database and not query for all databases. Seems like that is a permission not every admin would want a user to have. There could be other clients that have databases on that server, and you wouldn't want one client to see other client's database names.
For production systems, sure. But LLBLGen Pro is a development tool, so the philosophy is that the developer works with a development server, where the schema is accessible for the people who have to do development. Again, we simply obtain the list of databases to connect to using the MySqlConnection.GetSchema("databases") call, as we support multiple databases per project (so we have to let the user choose).