If it was a problem with mysql permissions you would get an access denied for user@host using password(YES/NO) error. Since the error is cannot connect through socket, either the socket is not in the specified directory or you do not have permission to it or mysqld is not running.
-----Original Message----- From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com] Sent: Monday, November 04, 2002 1:21 PM To: 'David Wu' Cc: Mysql (E-mail) Subject: RE: (beginner) mysql connection problem! You might also need to add hostname. It depends on what GRANT sql statement was used to add the user id. Something like mysql -u userid -p -h hostname dbasename should work. If not, check that mysqld is in fact running. You can use ps -aux | grep mysql Regards, ~Kelly W. Black -----Original Message----- From: David Wu [mailto:dwu@;stepup.ca] Sent: Monday, November 04, 2002 11:59 AM To: [EMAIL PROTECTED] Subject: (beginner) mysql connection problem! Hi everyone, On my local machine I had mysql installed, and I was able to log in and doing a test on it. but today as I am trying to login using >mysql or >mysql -u root -p, I got the error message saying; ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2), I had not touch the setting of the mysql at all. What should I do to solve this problem?? Thank you all for your help. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
