Posted by www.douglassdavis.com on 11/01/05 20:31

I screwed up the permissions on my database. Basically I revoked all
the permissions of the root account on the mysql table.

To try to fix this, I went through all of the instructions here:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

running:
mysqld-nt.exe --defaults-file="C:\Program Files\MySQL\MySQL Server
5.0\my.ini" --init-file=C:\mysql-init.txt


except in the mysql-init.txt file I put this:

GRANT ALL ON mysql.* TO root

Does any one know why this isn't working?

• Next in forum: Re: from PHP -> db2_connect() Undefined Function
• Prev in forum: Re: help please: insert string into file at specific location
• Thread view: MySql permission problems (Win 2000)

[Reply to this message]