Encountering connection issues with MySQL databases can be frustrating. This section provides a detailed explanation and resolution steps for common error messages.

Error Message: Unable to connect to the database, Please make sure that your database is running and that you have whitelisted our IP address 34.100.193.122.

Action Steps

1

Provide the IP

Ensure your MySQL server is running by trying to connect via a tool like MySQL Workbench or through the command line.
2

IP Whitelisting

Whitelist the IP address 34.100.193.122 in your MySQL settings, which might involve modifying firewall settings or MySQL user privileges.
3

Reach Out for Support

If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.

Error Message: Unable to connect to the database, Please ensure the database credentials are correct.

Action Steps

1

Verify

Verify that the username and password in your connection settings match the credentials in your MySQL server.
2

Reset password

If necessary, reset the password for the user in MySQL and update it in your connection settings.
3

Create a new username/password

Alternatively, it’s best to create a new username/password. Create user like this CREATE USER 'sammy'@'*' IDENTIFIED BY 'password'; and grant permission to databases like this GRANT PRIVILEGE ON database.table TO 'username'@'host';
4

Reach Out for Support

If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.

Error Message: Unable to connect to the database, Please make sure that the database exists.

1

Verify db name

Ensure that the database name in your connection settings matches an actual database in your MySQL server. Here’s the command: SHOW DATABASES;
2

Create DB

If the database does not exist, create it using a tool like MySQL Workbench or by executing a CREATE DATABASE SQL command.
3

Reach Out for Support

If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.

Error Message: Unable to connect to the database, Please make sure that your database is running and that you have whitelisted our IP address 34.100.193.122.

Action Steps

1

Verify liveness

Check if the MySQL server is operational and not experiencing downtime.
2

Whitelist IP

Whitelist the IP address 34.100.193.122 in your MySQL settings, which might involve modifying firewall settings or MySQL user privileges.
3

Reach Out for Support

If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.

​
Summarising all the errors that you could face while connecting to your MySQL DB

Was this page helpful?

IP WhitelistingOverview