Check the username and password

Oct 13, 2025 by pinkandtrash.com 105 views

Introduction

Connecting to a database through SQLPro can be a straightforward process, but sometimes, users encounter errors that prevent them from accessing their database. In this article, we will explore the issue of "Access Denied" when trying to connect to a MariaDB/MySQL database through SQLPro. We will provide a step-by-step guide on how to troubleshoot this issue and offer solutions to resolve the problem.

Describe the Bug

When creating a new connection through SQLPro, users may encounter the following error message:

"Access Denied for user 'devppslegendaryd'@'c-73-217-129-217.hsd1.sc.comcast.net' (using password: YES). (Error #1045)"

This error indicates that the user account 'devppslegendaryd' does not have the necessary permissions to access the database.

To Reproduce

To reproduce this behavior, follow these steps:

Create a new MariaDB/MySQL connection: Open SQLPro and click on the "New Connection" button.
Alias: Enter a name for the connection, such as "Dec Test".
Server Host: Enter the IP address of the server hosting the database, which is 67.227.154.93.
Server Port: Enter the port number used by the database, which is 3306.
Login: Enter the username for the database account, which is "devppslegendaryd".
Password: Enter the password for the database account, which is "Zp#Ebt%Q+[%Y".
Database: Select the database to connect to, which is "devppslegendaryd_2024-07-16".

Expected Behavior

The expected behavior is that the connection is established successfully, and the user has access to the database.

Screenshots

The following screenshots provide additional information about the issue:

Environment Details

The environment details are as follows:

Operating System: MacOS 15.3.1 (24D70) - Seqoia
Macbook Pro: M3
SQLPro Studio Version: 2025.1 (Build 111116)
Installed from: App Store
Database: MariaDB/MySQL

Additional Context

The user has attached various screenshots of the configuration and errors, as well as a screenshot of the IP entry in CPanel for remote database access. Additionally, the user is able to connect to the database from the same Mac using SQLWorkbench.

Troubleshooting Steps

To troubleshoot this issue, follow these steps:

Check the username and password: Ensure that the username and password entered in SQLPro are correct and match the credentials used in SQLWorkbench.
Verify the database account permissions: Check the database account permissions to ensure that the user account 'devppslegendaryd' has the necessary permissions to access the database.
Check the server host and port: Verify that the server host and port entered in SQLPro match the correct values.
Check the database name: Ensure that the database name entered in SQLPro matches the correct database name.
Check for firewall restrictions: Check if there are any firewall restrictions that may be blocking the connection to the database.
Check the SQLPro configuration: Check the SQLPro configuration to ensure that it is set up correctly and that the connection settings are accurate.

Solutions

Based on the troubleshooting steps, the following solutions can be applied:

Update the username and password: Update the username and password in SQLPro to match the correct credentials used in SQLWorkbench.
Grant necessary permissions: Grant the necessary permissions to the database account 'devppslegendaryd' to access the database.
Verify server host and port: Verify that the server host and port entered in SQLPro match the correct values.
Verify database name: Ensure that the database name entered in SQLPro matches the correct database name.
Disable firewall restrictions: Disable any firewall restrictions that may be blocking the connection to the database.
Update SQLPro configuration: Update the SQLPro configuration to ensure that it is set up correctly and that the connection settings are accurate.

Introduction

Connecting to a database through SQLPro can be a straightforward process, but sometimes, users encounter errors that prevent them from accessing their database. In this article, we will provide a Q&A guide to help users troubleshoot and resolve the issue of "Access Denied" when trying to connect to a MariaDB/MySQL database through SQLPro.

Q: What is the "Access Denied" error?

A: The "Access Denied" error occurs when the user account 'devppslegendaryd' does not have the necessary permissions to access the database.

Q: What are the common causes of the "Access Denied" error?

A: The common causes of the "Access Denied" error include:

Incorrect username and password
Insufficient database account permissions
Incorrect server host and port
Incorrect database name
Firewall restrictions
SQLPro configuration issues

Q: How do I troubleshoot the "Access Denied" error?

A: To troubleshoot the "Access Denied" error, follow these steps:

Check the username and password
Verify the database account permissions
Check the server host and port
Check the database name
Check for firewall restrictions
Check the SQLPro configuration

Q: What are the solutions to the "Access Denied" error?

A: The solutions to the "Access Denied" error include:

Update the username and password
Grant necessary permissions to the database account
Verify the server host and port
Verify the database name
Disable firewall restrictions
Update the SQLPro configuration

Q: Why am I able to connect to the database from SQLWorkbench but not from SQLPro?

A: There could be several reasons why you are able to connect to the database from SQLWorkbench but not from SQLPro. Some possible reasons include:

Different connection settings
Different database account permissions
Different SQLPro configuration settings

Q: How do I update the SQLPro configuration?

A: To update the SQLPro configuration, follow these steps:

Open SQLPro and click on the "Preferences" menu
Select the "Connection" tab
Update the connection settings as needed
Click "OK" to save the changes

Q: What are the best practices for connecting to a database through SQLPro?

A: The best practices for connecting to a database through SQLPro include:

Using the correct username and password
Verifying the database account permissions
Checking the server host and port
Checking the database name
Disabling firewall restrictions
Updating the SQLPro configuration

Conclusion

Connecting to a database through SQLPro can be a straightforward process, but sometimes, users encounter errors that prevent them from accessing their database. By following the troubleshooting steps and applying the suggested solutions, users should be able to resolve the "Access Denied" error and establish a successful connection to the database through SQLPro. Remember to follow the best practices for connecting to a database through SQLPro to ensure a smooth and secure connection.