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 [at] m.gmane.org
Asif Lodhi [ Mi, 21 Juni 2006 06:58 ] [ ID #1364337 ]

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 [at] gmail.com]
Sent: Wednesday, 21 June 2006 2:28 PM
To: win32 [at] 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 [at] m.gmane.org
jbonnett [ Mo, 26 Juni 2006 00:41 ] [ ID #1370569 ]
Datenbanken » gmane.comp.db.mysql.windows » Problem changing root password

Vorheriges Thema: Windows authentication on mySQL v 4.1.x
Nächstes Thema: can't unlock a "locked" table