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
Can't connect to Mysql
Re: Can't connect to Mysql
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.
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.
Re: Can't connect to Mysql
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.
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.