Aaron Gillette wrote:
> 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.
> I typed:
> 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:
> mysqladmin reload
> The Error:
> 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.
> Aaron Gillette
You only have the shareware/trial version 3.21.29.
The above mysqladmin syntax is based on at least 3.22.12.
So you are out of luck here.
Get a licenced version, or manipulate the mysql.* priviledge tables with UPDATE, INSERT,
DELETE and then make an mysqladmin reload.