Here is a question: Were you attempting to login on the localhost machine ?? Can you login to the MySQL server from an external client, in other words, outside of the localhost ??
When you do 'select host,user from mysql.user;' Does any user in the 'mysql.user' table have access ?? The should be an entry in the mysql.user table that has host='localhost' or host='%' The mysql client program may be finding the user you are specifying with proper host access. As a very last resort, if you cannot get in MySQL at all but can restart the mysqld daemon, restart MySQL with the option --skip-grant-tables. Then, change the mysql.user entries you want to give yourself proper localhost access. Then, at the mysql> prompt, run 'flush privileges;' to resume proper acess privileges for everybody else. Give this a try !!!! ----- Original Message ----- From: eng.waleed <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Wednesday, December 20, 2006 5:25:04 PM GMT-0500 US/Eastern Subject: socket error hi I have this error on mysql engine Could not connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) is there any suggestion my version is 3.23.58 BR -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
