Cindy writes: > >OK, it seems like every time I install mysql, I run smack dab into >some type of access problem -- if it isn't a password hangup, it's a >mysql.sock problem or (at the moment) a refusal to allow me to create >databases. I've puzzled through most of it for now, but this one >has me stumped.
Now I'm getting: mysql_att> /usr/local/mysql/bin/mysqladmin -u root password '***' /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' The documentation on Access_denied does say: If you get an error like the following: shell> mysqladmin -u root -pxxxx ver Access denied for user: 'root@localhost' (Using password: YES) It means that you are using a wrong password. See section 4.3.6 Setting Up Passwords. If you have forgot the root password, you can restart mysqld with --skip-grant-tables to change the password. But that's not quite the same command I used, and that's got password YES. And mind you, this is what I'm doing right after the mysql_install_db script and starting up the safe_mysqld for the first time. So of *course* there's no password. Spinning away, --Cindy --------------------------------------------------------------------- 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