Technote Details :: Cannot create queries using MX Query Builder

When I try to create my first query with MX Query Builder I get an error message:

This error occurs because one of the following:

1. The database connection does not exist, or an error occurred connecting to the database.
2. The user which connects to the database does not have permissions to create new tables.
3. The user which connects to the database does not have permissions to insert data into a table.
4. You have a ColdFusion data source configured to use a MySQL database through a JDBC connector. The connector version is 3.0.6 or higher. Starting with the 3.0.6 version the connector no longer allows creating tables or altering their contents.

To solve this problem, try one of the following:

• First make sure that the database connection exists and the web server can actually connect to the database.
• Check that the user name used in the database connection has permissions to create tables and insert data into them. If it does not have them, consult your database server documentation to find out how to grant these permissions.
• If in case four, you must use a different type of connection, or a JDBC prior to version 3.0.6.