Re: [PHP] Socket error connecting to mySQL
On Friday 21 February 2003 15:49, Bryan Lipscy wrote: $db= @mysql_pconnect ( $DB_HOST , $DB_USER , $DB_PASS ); @mysql_select_db ( $DB_DB ) or die ( DATABASE ERROR!.mysql_error() ); Returns DATABASE ERROR!Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) MySQL server exists on a Win2ksp3 box. Apache with PHP 4.3.0 exists on a Slackware 8.1 box. All parameters are correct. Boxes can see each other. All php scripts work when run on the Win2k box. Any ideas why connecting to php/mysql would throw this error? Search the archives or search the mysql list archives. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Loose bits sink chips. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Socket error connecting to mySQL
Hi I think that you mysql server on your Win box is set to only connect from localhost and not from an outside host which is what its trying to do. - Regards Nick Kordas BE(hons) Ph.D(usyd) Wildthing Communications PH: 07 5481 6064 Mob: 0421 556847 ICQ# 64851373 PO Box 1841 SUNSHINE PLAZA Maroochydore QLD 4558 http://www.wildcomm.net ~~~ How can a species, that can create machines to communicate, fail to communicate amongst themselves ? ~~~ This email and any files transmitted with it may be legally privileged and confidential. If you are not the intended recipient of this email, you must not disclose or use the information contained in it. If you have received this email in error, please notify us by return email and permanently delete the document. ~~~ - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 04, 2003 6:12 PM Subject: Re: [PHP] Socket error connecting to mySQL On Friday 21 February 2003 15:49, Bryan Lipscy wrote: $db= @mysql_pconnect ( $DB_HOST , $DB_USER , $DB_PASS ); @mysql_select_db ( $DB_DB ) or die ( DATABASE ERROR!.mysql_error() ); Returns DATABASE ERROR!Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) MySQL server exists on a Win2ksp3 box. Apache with PHP 4.3.0 exists on a Slackware 8.1 box. All parameters are correct. Boxes can see each other. All php scripts work when run on the Win2k box. Any ideas why connecting to php/mysql would throw this error? Search the archives or search the mysql list archives. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Loose bits sink chips. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Socket error connecting to mySQL
did u turn mysql on? end of mysql installation output: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h CPE00022af118a5-CM024330008757.cpe.net.cable.rogers.com password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd / ; /usr/bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Bryan Lipscy wrote: $db= @mysql_pconnect ( $DB_HOST , $DB_USER , $DB_PASS ); @mysql_select_db ( $DB_DB ) or die ( DATABASE ERROR!.mysql_error() ); Returns DATABASE ERROR!Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) MySQL server exists on a Win2ksp3 box. Apache with PHP 4.3.0 exists on a Slackware 8.1 box. All parameters are correct. Boxes can see each other. All php scripts work when run on the Win2k box. Any ideas why connecting to php/mysql would throw this error? Bryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Socket error connecting to mySQL
$db= @mysql_pconnect ( $DB_HOST , $DB_USER , $DB_PASS ); @mysql_select_db ( $DB_DB ) or die ( DATABASE ERROR!.mysql_error() ); Returns DATABASE ERROR!Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) MySQL server exists on a Win2ksp3 box. Apache with PHP 4.3.0 exists on a Slackware 8.1 box. All parameters are correct. Boxes can see each other. All php scripts work when run on the Win2k box. Any ideas why connecting to php/mysql would throw this error? Bryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php