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
