First, for some reason the connection attempt is defaulting to the user ODBC (probably set in one of the my.* files). If this user does not exist in the database, it will naturally fail.
Second, concerning the root user, there are actually 2 root user entries that need the password changed or one user removed. Specifically: From 4.2.11 Causes of Access denied Errors A very common error is to insert a new entry with Host='%' and User='some user', thinking that this will allow you to specify localhost to connect from the same machine. The reason that this doesn't work is that the default privileges include an entry with Host='localhost' and User=''. Because that entry has a Host value 'localhost' that is more specific than '%', it is used in preference to the new entry when connecting from localhost! The correct procedure is to insert a second entry with Host='localhost' and User='some_user', or to remove the entry with Host='localhost' and User=''. See the full documentation: http://www.mysql.com/doc/en/Access_denied.html -- Loren McDonald [EMAIL PROTECTED] -----Original Message----- From: daniel [mailto:[EMAIL PROTECTED] Sent: Sunday, March 09, 2003 1:15 AM To: Philip McCarthy; [EMAIL PROTECTED] Subject: RE: inquiry have u set the pass or is it correct ? usually mysqladmin -u root password newpassword then mysqladmin -u root -p create sample_db >===== Original Message From "Philip McCarthy" <[EMAIL PROTECTED]> ===== >Dear mysql > > > >I have just downloaded mysql 3.23 for Windows and I am running XP. > > > >I have started the service ok and create a database. I thought I had >set my database password ok. I have been using the book 'Teach Yourself >MySQL in 21 days' by SAMS (Mark Maslakowski). > > > >When I try the statement > > > >bin\mysqladmin -p CREATE sample_db > > > >the command asks for a password. I type in the one I set and the system >says > > > >mysqladmin: connect to server at 'local host' failed > >error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' > > > >Does it appear that I need to install an ODBC driver? > > > >Your help is appreciated. > > > >Yours Sincerely > > > >Philip McCarthy > >NSW Australia > > > >--------------------------------------------------------------------- >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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
