GoDaddy MySQL Stuff

[Troy297]

Hey,

I have just finished making a large-scale project for a client of mine and when I went to move it over to his servers I got a little confused. He uses GoDaddy and their control panel is completely different than what I'm used to (cPanel 11)... so I need some help :P

I have successfully transfered the database over but now I can't seem to connect to it... oddly enough? Do I have to use some different kind of php connection script to connect to their databases or something? Here's what I currently use:

PHP Code:

$dbhost = "h50mysql9.secureserver.net";
$dbuser = "user_here";
$dbpass = "password_here";
$dbname = "name_here";
$db = mysql_pconnect($dbhost,$dbuser,$dbpass); 
mysql_select_db("$dbname",$db); 


Is that okay? I'm not sure... a quick reply would be greatly appreciated! Thanks!

[_Aerospace_Eng_]

I don't know if you can use pconnect on godaddy. I use mysql_connect and I'm able to connect to my database. Open the database manager to be sure you are selecting the right database. echo out mysql_error() to see if something is wrong.

[CFMaBiSmAd]

Someone correct me if I am wrong, but godaddy runs PHP as a CGI wrapper.

If the above statement is true, then pconnect won't work as expected. I believe a mysql_pconnect would behave exactly like a mysql_connect under these conditions.

Adding the error reporting that _Aerospace_Eng_ suggested will help pinpoint if this is the case. Also, check the web server log file for errors and/or put the following two lines in after your first opening <?php tag -

PHP Code:

ini_set ("display_errors", "1");
error_reporting(E_ALL); 


[NancyJ]

Just to probably state the obvious (you never know) did you change the username and password in your script. When you transfered the databases its probable that you didnt also transfer the users and permissions.

[Troy297]

Originally Posted by NancyJ

Just to probably state the obvious (you never know) did you change the username and password in your script. When you transfered the databases its probable that you didnt also transfer the users and permissions.

Lol - yes I did infact change the username/password/db name when I switched it, that was the first thing I checked.

As for the mysql_error reporting thanks! I will try that tonight and see what I get +rep both of you!

[Troy297]

Okay... tried echoing the error while using mysql_connect instead of pconnect and got this message:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

[_Aerospace_Eng_]

Try this

PHP Code:

$dbhost = "h50mysql9.secureserver.net";
$dbuser = "user_here";
$dbpass = "password_here";
$dbname = "name_here";
$db = mysql_connect($dbhost,$dbuser,$dbpassword) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error()); 


[Troy297]

Still getting the error:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Wait! and now its changed... sometimes I get this:

Can't connect to MySQL server on 'localhost' (10061)

But thats only when I use this code:

PHP Code:

$dbhost = "h50mysql9.secureserver.net";
$dbuser = "user";
$dbpass = "pass";
$dbname = "name";
$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
echo mysql_error(); 


Heres the page:
http://soulandbluesreport.com/new/index.php

[_Aerospace_Eng_]

Just tried your original code on my godaddy account and was able to connect to the database just fine even using pconnect.

I think you need to contact godaddy.

[Troy297]

Okay - will do Thanks for the help!

[marek_mar]

The "Can't connect to MySQL server on 'localhost' (10061)" is because you check the error after the mysql_select_db() call, which attempts to connect with it's default settings (found in php.ini).

[Troy297]

I finally figured it out!

After emailing GoDaddy Support they told me that Windows Hosting does not support PHP! I felt so stupid! But anyways... now I have to try and get my client to switch his hosting to Linux :S

Thanks for all the help!!

[_Aerospace_Eng_]

I thought their Windows plans had support for php and asp, maybe thats just for some of them.

[Troy297]

Originally Posted by _Aerospace_Eng_

I thought their Windows plans had support for php and asp, maybe thats just for some of them.

Close but not quite.... their Windows Hosting Plans only have ASP (with Access, MySql, and SQL Databases). If you want PHP, CGI, MySQL, etc. you need their Linux Hosting.

Who knew eh?

[Fumigator]

You're gong to want to switch hosts once you discover Godaddy is running MySQL 4.0 and has no plans to upgrade.

Our support staff has responded to your request, details of which are described below:

Discussion Notes
Support Staff Response
Dear Randy Whitaker,

Thank you for your email. We apologize for the inconvenience, but currently we have no schedule for upgrading MySQL. Please send this suggestion to suggestions@godaddy.com as many of our products and features have either been created or improved by customer suggestions.

Please let us know if we can help you in any other way.

Sincerely,

Aris Q.
Customer Care Specialist
Customer Inquiry
Browser Info : Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6

What are your plans for upgrading MySQL to 4.1 or (preferrably) 5.0? Version 4.0 has many drawbacks I am running into; namely, subselects do not work. Do you have a schedule for upgrades?