Problem changing root password

hi All,

When I try to change root user-password from the shell using ANY of
the methods described in the reference manual, it says that the USERS
table is read-only. My root password is blank and it's giving me
creeps. There MUST be a way to change the root password. I am using
the stable recommended release - 5.0.22-community-debug.

Any hints?

--
Asif

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Problem changing root password

I presume it lets you login OK as root with the blank password?

Is there any other reason the USERS table might be read-only, e.g. the
O/S permissions or file attributes?

Something like copying the install files from a CDROM might leave them
read-only, which could cause this problem.

John B.

-----Original Message-----
From: Asif Lodhi [mailto:itmailster@gmail.com]=20
Sent: Wednesday, 21 June 2006 2:28 PM
To: win32@lists.mysql.com
Subject: Problem changing root password

hi All,

When I try to change root user-password from the shell using ANY of
the methods described in the reference manual, it says that the USERS
table is read-only. My root password is blank and it's giving me
creeps. There MUST be a way to change the root password. I am using
the stable recommended release - 5.0.22-community-debug.

Any hints?

--
Asif


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org