Quote:
Originally Posted by Glenn D.
Hello,
# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
|
[EDIT] For clarity... [/EDIT]
In my experience the user, even with
--skip-grant-tables, must still be identifiable. In other words, you still could not start the mysql client with
mysql -u nobodyhome.
And on my own systems,
-u root results in the error message that you see, whereas
-u root@localhost does not (I do not fully understand why, but that is how it works).
So...
Code:
mysql -u root - Does not work
mysql - Does work for local users including root
mysql -u root@localhost - Does work