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
