on 3/3/01 4:54 PM, Jonathan Dugan at [EMAIL PROTECTED] wrote:
> and I follow what is says:
> shell> mysql -u root mysql
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
It sounds like you've _already_ set a root password, so you need to specify
it:
mysql -u root -p
With the -p parameter it will prompt you for a password on stdin. Supply the
root password and you should be in. If you don't specify -p on the command
line, it assumes you are attempting to gain access without a password, and
your security isn't set up to allow this.
This is a bit confusing at first...
But the security model in mysql is really very elegant once you understand
what's going on...
Hope this helps,
Geoff
---------------------------------------------------------------------
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