MySql permission problems (Win 2000)

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?

Re: MySql permission problems (Win 2000)

www.douglassdavis.com wrote:
>
> 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?
>

Try comp.database.mysql. This is a PHP newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: MySql permission problems (Win 2000)

www.douglassdavis.com wrote:
>
> 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?
>

Try comp.database.mysql. This is a PHP newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================