learning through interaction
If you are a developer and you do some sort of backend work there is a chance one of your clients might ask you to install an application in GoDaddy servers.
So if you are trying to connect to a dabase within your application what GoDaddy recommends is to use mysql.secureserver.net as your hostname. Maybe this could have worked while back but that information is not true for all servers.
If you are having problems all you have to do is login to your GoDaddy control panel and look what server has GoDaddy assigned for you, at least that is how it worked out for me.
During the day I work as a Sr. Rich Media Designer for T3, During the evenings I enjoy the best time of the day as a husband and a father and sometimes during the nights I work for myself at multimedia247.
This blog is mostly about my findings on the web, my contribution to noobs to flash that might be able to learn something from the site. If you dont consider yourself a noob and you still were able to learn or discover something new on this blog, even better.
Akhtar
September 19th, 2007 at 1:39 pm
I’ve just created a database using godaddy, but when i try to use their openmanager I get the error ‘Cannot log in to the MySQL server’ . I’ve triple checked my credentials and the secureserver.net bit is okay, . unless their is some wait time to be done, i’m bamboozled.
Hooman
October 28th, 2007 at 3:07 pm
I’m having the same problem!!! It’s so frustrating, especially considering that Godaddy support has no clue.
SS
October 28th, 2007 at 3:07 pm
I’m having the same problem!!! It’s so frustrating, especially considering that Godaddy support has no clue.
C Snover
November 28th, 2007 at 7:18 pm
This is the first hit for “GoDaddy cannot log in to the MySQL server” in Google, so here’s the answer:
GoDaddy is using old password hashing, so passwords longer than 14 characters are truncated to the first 14 characters. Use the first 14 characters of the password you entered and it will log in successfully.
Helmut
November 29th, 2007 at 3:33 pm
@C Snover
Thanks so much for the information… something else people can think about when debugging their applications.
SnowHover
January 12th, 2008 at 6:25 pm
The “first 14 characters of the password” thing didn’t work out for me. I’ve even set the password to 7 characters long (the minimum allowed) and it still ‘Cannot log in to the MySQL server’.
Andrew Spiering
January 24th, 2008 at 4:45 pm
I can not log-in either and am really frustrated. I changed my password several times and still can’t access MySQL database. Does anyone have any more information? Thanks!
Will England
March 5th, 2008 at 6:22 pm
OMFG - what a fine pile of stuff! I was using a ’secure’ 20 char password. Dropped the last 6 chars and was able to log in no problem.
Thanks for the hit!
Will
Joe Random
April 11th, 2008 at 9:13 pm
Had the same problem, the solution was indeed to shorten the password to 14 chars max. Thanks!