This morning I downloaded the MySQL 3.1.29 for Win32. I installed it on my
Windows 98 machine, which seemed to go fine. I started mysqld. The next step
was to change the root password.
mysqladmin -u root password 'mypassword'
The response was:
C:\MYSQL\BIN\MYSQLA~1.EXE: unable to cahnge password; error: 'parse error
near' SQL_OPTION password='59d9abe742b7104e'' at line 1'
I've tried every variation I can think of, nothing works.
I'm also having problems with the command:
C:\MYSQL\BIN\MYSQLA~1.EXE: reload failed; error: 'Access denied for user: '
These problems are undoubtedly related.
I've scoured the docs & O'Reilly's book, but can't find the answer.
Any help will be greatly appreciated.