This posting follows on from the thread of postings in the newsgroup
started at:
http://groups.google.co.uk/group/com...920bf3f04e5ccc
which lapsed after 60 days.

After a couple of months I have got back to trying to install the
current release of version 5 of MySQL.

As I stated in my earlier posting I have currently installed on my PC
(Windows XP, SP2) MySQL version 4.06. Most of the files in the \bin
directory are dated 12-16-2002.

The last contributor to the previous thread (Axel Schwenke) was most
helpful.

Taking his suggestion, I opted for installing MySQL version 4.1 (from
downloaded file mysql-4.1.22-win32.zip).

The reason for this was that going from version 4.0 to 5 was thought to
possibly be too great a leap. The idea is to get 4.1 up and running and
then install the latest release of version 5. There are instructions in
the version 5 manual for upgrading from 4.1 to the current release of
version 5.

I followed the guide for using the install wizard in "Installing MySQL
4.1.7 - (Windows)" at:
http://www.idevelopment.info/data/My...WIN417_4.shtml

Installation of 4.1 went ok. But I got into a muddle over passwords.

I have been driving MySQL 4.0 for over three years from local web pages
via localhost. In that system I used no password. I can't remember how
I installed 4.0 with no password requirement.

I wanted to do the same with version 4.1 but when I got to the security
options dialog box I left "Modify Security Options" checked and
supplied "password" as the password. I then proceeded to complete the
install wizard.

I put "password" into my ODBC connect string but I get the error
messages: "Access denied for user 'root'@'localhost' using password:
NO" or "Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost'
(using password: NO)/pdm/DBM_test.asp, line 5".

I have done all sorts of things to alter the password in the server via
mysqladmin, etc. but I kept getting the same error messages.

Finally, I uninstalled and ran the installation procedure again. This
time I unchecked "Modify Security Options".

This did not work either.

Could someone please tell me step-by-step how to either carry out the
installation correctly regarding passwords or fix the current
installation.

Thanks for your help.