Mysql


#1

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


#2

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.


#3

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


#4

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…


#5

excellent!! thank you.
it loaded successfully.

THANK YOU

Chunky