Loren Firstly thanks heaps for your reply. I will try and be as specific as possible to not waste your time.
If indeed the connection is defaulting to the user ODBC and it is set in one of the my.* files, where can I see this? Fix this? I should go back a bit and mention that as I was working through my book, the first hurdle I encountered was setting up the initial grant tables. When I typed c:\mysql\scripts\mysql_install_db I got the error message: 'mysql_intall_db' is not recognized as an internal or external command, operable program or batch file. I uninstalled mysql, resintalled and still got the same message. I gather this should have worked? I did this by opening 'run' from the start bar, typing in cmd to open the command line, cd \ to change to the root directory, cd mysql to change to the mysql folder, cd scripts to change to the scripts folder and then mysql_install_db to run this. No luck. Yours Sincerely Philip McCarthy Australia -----Original Message----- From: Loren McDonald [mailto:[EMAIL PROTECTED] Sent: 09/03/2003 7:15 PM To: 'daniel'; 'Philip McCarthy'; [EMAIL PROTECTED] Subject: RE: inquiry 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