Cannot connect to mysql from PHP

Question

The credentials are working from mysql workbench, but when I try it from PHP it takes a lot of time loading then gives 500 - internal server error.

$DB_HOST = some ip here (NOT localhost or 127.0.0.1) ;
$DB_USER = "myuser";
$DB_PASS = "mypassword";
$DB_NAME = "mydb";

$db = mysql_connect($DB_HOST, $DB_USER, $DB_PASS);

mysql_select_db($DB_NAME,$db) or  die("Error In database");

This was working on the dev server, but when moved to a new server it doesnt.

it might be useful to mention that the server runs PHP 5.4 so mysql_connect works fine.

I appreciate if you can help.

Is was the dev server on the same host as the db? And does it give you an sql error? — Trudbert, Aug 15 '14 at 06:30
did you looked in your error log files? Perhaps reason not in connection. Maybe htaccess or something else — Vasiliy vvscode Vanchuk, Aug 15 '14 at 06:32
@Trudbert the host is different than the DB, it doesnt give any errors, just takes a bit of time then gives 500 internal server error — Digital fortress, Aug 15 '14 at 06:38
@emmanuel wont work because the host is different than mysql — Digital fortress, Aug 15 '14 at 06:39
If you get a 500 error, look at the error logs of your webserver. There usually is a clear message what the problem is. — Gerald Schneider, Aug 15 '14 at 06:45
Another note: the `mysql_*` functions are becoming deprecated and will be removed from future versions of PHP. You should not write new code using them. Use `mysqli_*` or PDO instead. — Gerald Schneider, Aug 15 '14 at 06:46
@VasilVanchuk I dont have access to logs now, but I'm sure its the connection, as I tried running php pages with no connection and work fine — Digital fortress, Aug 15 '14 at 06:46
@GeraldSchneider Thanks for the note, its not my choice though — Digital fortress, Aug 15 '14 at 06:47
You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). — Quentin, Aug 15 '14 at 06:49
Does workbench run the new server? If not have you checked the firewall settings for the new server? — Trudbert, Aug 15 '14 at 06:49
Does the user you are trying to login as have appropriate permissions to login to a remote server? — Daryl Gill, Aug 15 '14 at 06:51
@Trudbert will check firewall settings, thanks for bearing with me — Digital fortress, Aug 15 '14 at 06:55

score 0 · Answer 1 · answered Sep 01 '14 at 15:44

0

if you use cpanel as your hosting, you have to set database user in MYSQLDATABASE menu then you have to use prefix in DBUser and DBName like 'user_table' and 'user_db'

answered Sep 01 '14 at 15:44

Shen Siddharta

50
7

Cannot connect to mysql from PHP

1 Answers1