Can't connect to Mysql

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Mike T
Posts: 2
Joined: Thu 21 Feb 2013 13:39

Can't connect to Mysql

Post by Mike T » Thu 21 Feb 2013 14:22

Hi all first time here. Very new to MySQL and database so please keep any replies simple so I can understand what you mean.

I could do with help with the following,
New connection. Database connection properties, I am trying to connect to my MySQL database that I have at Hostroute cPanel.

I have filled out the window with everything from Host: to Database: then I press Test, I get a pop up with the following on
Access denied for user 'Syndica1-Mike'@'cpc20-stkn13-2-0-cust60.11-2.cable.virginmedia.com' (using password: YES)

What does this mean? How can I sort this? Please give step by step details please
I use windows 7.
I hope I have posted in the correct place.

Many thanks in advance

alexa

Re: Can't connect to Mysql

Post by alexa » Fri 22 Feb 2013 15:27

Please consider the following possible causes of this error message:

1. Incorrect password is entered.
2. The user 'Syndica1-Mike' doesn't exist on the server 'cpc20-stkn13-2-0-cust60.11-2.cable.virginmedia.com'. It means that there may exist the user 'Syndica1-Mike'@'Localhost' that can connect only to localhost. So, if you are connecting from outside, you need to create another user, e.g., 'Syndica1-Mike'@'%' that can be used to connect to the server from any host, or 'Syndica1-Mike'@'cpc20-stkn13-2-0-cust60.11-2.cable.virginmedia.com' to connect exclusively from the 'cpc20-stkn13-2-0-cust60.11-2.cable.virginmedia.com' host.

Mike T
Posts: 2
Joined: Thu 21 Feb 2013 13:39

Re: Can't connect to Mysql

Post by Mike T » Sun 24 Feb 2013 09:45

Thanks for your reply alexa.

I have sorted it now.

It was simply case senitive Syndica1-Mike, should of been syndica1-Mike

Thanks

Now down to learning how to get started.

Post Reply