PDA

View Full Version : MySql setup problem (newbe)


nigel
12-18-2003, 09:34 AM
When setting up, I get the following errors,

The error was reported as:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I have confirmed the settings I have entered with mi host, they are

$dbHost = "localhost";
$dbUserLogin = "dmcf";
$dbPassword = "xxxxxx"; changed for obvious reasons
$dbName = "dmcf_org_uk_-_cal";

the demo also reports the same errors, really

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/cal/escal.php on line 167

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/html/cal/escal.php on line 168

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/html/cal/escal.php on line 171

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/cal/escal.php on line 172

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/cal/escal.php on line 180

Advise?

revoemag
12-18-2003, 10:12 AM
This error message means that the mysql daemon/service is not running. First verify that mysql is started.

Linux: ps -aux | grep mysql

Windows: Task Manager -> Processes
or Control Panel -> Admin Tools -> Services

If it is not running, start it.

rev

nigel
12-18-2003, 11:05 AM
Problem solved, it was to do with security settings on the server, the mysql was running, when reduced security for a bit, all worked:))


Many Many thanks for your help