Access Denied to a MYSQL DB from a Windows 7 computer

Asked by:
HubFans / n/a Points
Time:
2015-12-25 9:36 am EST
Category:
General Information
Hits:
64
Hi.
I'm trying to connect to a MySQL DB I created on my gofuturevisions.com account with you. I made sure user name and password is correct and tried using localhost and tried using whub27.webhostinghub.com. The message is: Access denied for user 'gofutu5_ccreport'@'localhost'(using password: YES)

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

ScottM
Staff
16,266 Points
2015-12-27 6:08 pm EST
Hello!

Sorry to hear you are having issues with connecting to MySQL remotely from a local Windows machine.

As long as you are using a good remote connection program such as HeidiSQL or MySQL Workbench, the specific type of computer you are using to connect will not matter (Mac, Windows, Linux, etc.)

Of course, be sure you have set your account to allow your local network's IP address to connect to the server.

Next, check all the settings you have in the connection program to ensure they are correct. For example, a common mistake is to use 'localhost' as a hostname. This will not be correct as it is a remote connection. In that case, you want to use the server name itself, or the domain name (assuming it is pointed to the server.)

The database name and password are located in the database information under the Databases category in the cPanel. The name should be in two parts like userna5_dbname in this case, userna5 is your cpanel username and the dbname portion is the specific database name. You will want to use the whole thing. The password will be the one for that specific database user, not your cpanel password.

Check the first link above in my answer for more information on the settings.

After all those are correct, you should be able to connect without any issue.

Kindest Regards,
Scott M

To submit a comment on this answer, please first login.

Want to share this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.