Mysql

hi,
i am trying to load my newly created mysql datbase by entering into browser the following: http://www.atlantametrorealty.net/install.php

i am getting the error message:
Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) in /home/.faysidiousblender/chunky/atlantametrorealty.net/conn.php on line 28
Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

The only information that i was required to modify was in the conn.php file and these changes were:
//enter your MySQL database host name, often it is not necessary to edit this line
$db_host = “localhost”;

//enter your MySQL database username
$db_username = “db_username”;

//enter your MySQL database password
$db_password = “password”;

//enter your MySQL database name
$db_name = “db_name”;

//enter your URL
$site_url = “http://www.yourdomain.com”;

which i changed to:
//enter your MySQL database host name, often it is not necessary to edit this line
$db_host = “localhost”;

//enter your MySQL database username
$db_username = “chunky”;

//enter your MySQL database password
$db_password = “i put my password here”;

//enter your MySQL database name
$db_name = “estamr”;

//enter your URL
$site_url = “http://www.atlantametrorealty.net”;

any thoughts?

Chunky

This must be the single most frequently asked question here.

$db_host = “localhost”;

This is incorrect. When you created your database you also chose a hostname. Use that in place of “localhost”.


If you want useful replies, ask smart questions.

first of all, thanks for your response. i did play with that some and when i changed it, here’s the error message i received:
Warning: mysql_connect(): Unknown MySQL server host ‘amr.atlantametrorealty.net’ (1) in /home/.faysidiousblender/chunky/atlantametrorealty.net/conn.php on line 28
Unknown MySQL server host ‘amr.atlantametrorealty.net’ (1)

unfortunately, i can’t remember if it’s amr.atla… or estamr.atlanta… but i did try both and received the same error.

thanks.

Chunky

How long ago did you set those databases up? Which server are they on? You can go to Status >> Mysql Usage to see what server that database is on.

I checked and neither are working. Make sure the name is correct. When your database is active and working, you should be able to go to http://amr.atlantametrorealty.net you can then type in your username and password and access your database.

Log into your webid, go to the goodies section >> mysql and see if you have the right database name, user, etc.

It also sometimes takes longer than the 10 minutes to get it set up…

excellent!! thank you.
it loaded successfully.

THANK YOU

Chunky