Re: MySQL Error Number 1045 Access denied

[Rob Van Dell]

Wow, long thread.

In all versions of the current MySQL online manuals, in
section 2.9.3 "Securing the Initial MySQL Accounts"
the solution information is provided.

(when you're done throwing food; read on).

On Linux I've always used;

Prompt-> mysql -u root -p
Enter Password: <cr>

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 717 to server version: xx-xxx-xxxx

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Since there is no password yet, you get in.!

Notice that I used -p since the "...using password NO" error would
result if I had not! The initial grants have Using Password YES by default
even if it is null.

The default MySQL installation accounts are root and one or two other
users depending on your platform. Not to be confused with any platform
user logins..

Note: Simply sayng mysql <cr> will pick up the currently logged in user name
@ localhost, and unless you're logged in as root on a Linux / Unix box won't be
in the grants tables yet..

If it ever demands a password after install always try "monty" which
is Michael "Monty" Widenius nick name. (one of the founders).

It once did infact install a default password, and that was always
"monty"... but at the time, the docs clearly stated this too...

(ok, continue throwing food..)