Warning: mysql_connect() HELP!!

da1llustrator · **Joined:** Tue Nov 28, 2006 3:29 pm **Posts:** 1

Hi, I'm trying to use a php script to connect to my database, but I keep getting the following error:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/garpoo.100webspace.net/inc/config.inc.php on line 2117
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

btw, here is the code in my script:

function db_open ()
{
global $settings;
if (!($dbconn = mysql_connect ($settings['mysql1.100ws.com:3306'], $settings['garpoo_test'], $settings['*****'])))
{
exit (mysql_error ());
;
}

if (!mysql_select_db ($settings['garpoo_test']))
{
print mysql_error ();
exit ();
}

return $dbconn;
}

function db_close ($dbconn)
{
mysql_close ($dbconn);
}

Parameters for hostname, login, and password should be all correct. What do I need to do to get this working? Do I need to have a mysql.sock file? I am still very new to database management. Any help would be appreciated. Thanks a bunch!

scragar · **Joined:** Fri May 13, 2005 10:24 am **Posts:** 54

I'm a little confused with what you are doing here, normally when storing data to a variable it's usage would be something like:

Code:

$settings = array(
  'host'=>'mysql1.100ws.com:3306',
  'username'=>'garpoo_test',
  'password'=>'******'
);

function db_open(){
  global $settings;
  if(!($dbconn = mysql_connect ($settings['host'], $settings['username'], $settings['password']))){
      die(mysql_error ());
  } 
....

Forum rules

Warning: mysql_connect() HELP!!