URGENT - user permissions

[jgentes]

I was using a front-end client (MySQL Administrator) and in the process of adding a new user, I deleted the 'root' privileges. I can still sign onto the 'root' account, but I cannot access any of the databases. This was the only login in the system that has full rights such as this. Is there some script I can do to give myself full privileges again?

[bartonc]

I was using a front-end client (MySQL Administrator) and in the process of adding a new user, I deleted the 'root' privileges. I can still sign onto the 'root' account, but I cannot access any of the databases. This was the only login in the system that has full rights such as this. Is there some script I can do to give myself full privileges again?

I dug this answer up on google.

"DBS" <help@stripped> wrote:
> I have a problem, It's been months since I used MySQL and (I believe) I had
> set it up with a root password. Now I can't log on to MySQL as root MySQL
> user and create a new user or manage an existing user (I can log onto server

Familiar situation. :)

Do so:

service mysql stop

wait until MySQL shuts down. Then run

mysqld_safe --skip-grant-tables &

then you will be able to login as root with no password.

mysql -uroot mysql

In MySQL command line prompt issue the following command:

UPDATE user SET password=PASSWORD("abcd") WHERE user="root";
FLUSH PRIVILEGES;

At this time your root password is reset to "abcd" and MySQL will now
know the privileges and you'll be able to login with your new password:

mysql -uroot -pabcd mysql

[jgentes]

I tried google myself, but I guess I wasnt using the appropriate search terms. THANK YOU!

1) is it necessary to be at the specific terminal? because I am hosting it somewhere else.

2) after I do that will I need to do service mysql start ? or something? or will it automatically restart after I login with the blank root permissions..

[bartonc]

I tried google myself, but I guess I wasnt using the appropriate search terms. THANK YOU!

1) is it necessary to be at the specific terminal? because I am hosting it somewhere else.

2) after I do that will I need to do service mysql start ? or something? or will it automatically restart after I login with the blank root permissions..

You are welcome. The keywords were "MySQL lost password".
I'm spoiled, in that I always have my hands on the server (development machine). From here MySQLAdmin has no problem stopping the service.

I'm guessing that you'll need to restart the service.

Good luck.