Dave
[ mysql query]
> when I installed mysql 3.23.43 it instructed me to be sure to add a password with
>the following results-
> :
> seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password'
> Enter password:
> /usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Read the man pages for mysqladmin for full details on all options (there
are lots of them ;-P).
The option "-p" is the password you use to connect to the server,
however on a default installation you should specify no password.
Essentially what you're doing is saying:
"Connect me to the server at 'localhost' with the password 'password'
and user 'root'"
...which is NOT what you want to do because the default databases don't
expect a password _at all_ [which is why it is strongly suggested you
change the passsword]
Drop the "-p" so it looks like:
/usr/mysql/bin/mysqladmin -uroot password 'newpassword'
Also, don't forget to flush the privileges after changing the password.
DSL
--
We are not the United States' ally
We are the 53rd sovereign state
of the Federation
-
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