PHP 4.0 Bug #7856 Updated: PHP can't conect to mysql server

ID: 7856 Updated by: sniper Reported By: javierdeco@hotmail.com Status: Closed Bug Type: MySQL related Assigned To: Comments: User feedback: ----------- >1. Does simple mysql_connect("localhost", "user", "password") >work? No, it doesn't work. >2. Are you sure you have mysqld up and running? Yes, I am >3. Can you connect to mysql using the mysql shell utility from command >line? No, I can't. I can connect only when log on as root. When I log on with my user I can't connect and get the same error. Could you please give any idea to resolve it? ---- Obviously you haven't configured mysql correctly. Please refer to http://www.mysql.com/ for further information on how to configure mysql. Or ask on php-db@lists.php.net This bug system is meant for reporting possible bugs in PHP. This is not a bug. --Jani Previous Comments: --------------------------------------------------------------------------- [2000-11-18 22:43:52] sniper@php.net 1. Does simple mysql_connect("localhost", "user", "password") work? 2. Are you sure you have mysqld up and running? 3. Can you connect to mysql using the mysql shell utility from command line? --Jani --------------------------------------------------------------------------- [2000-11-16 21:17:56] javierdeco@hotmail.com I got this message trying to connect to mysql database from my php page. ----------------------------------- Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock:' (111) in /var/www/html/table.php on line 17 -------------------------------- The line 17 is: mysql_connect('localhost:3306:/var/lib/mysql/mysql.sock:','root','decomysql'); --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=7856