You are not logged in.

#1 2006-04-20 18:54:27

clank
Member
Registered: 2005-04-11
Posts: 35

MySQL privileges problem

I was modifying the privileges in phpMyAdmin and accidentally removed them from root instead of another user (who can't modify privileges)  :x

Is there a way to modify the privileges at this point?


=> Now known as jb

Offline

#2 2006-04-21 07:48:19

FUBAR
Member
From: Belgium
Registered: 2004-12-08
Posts: 1,029
Website

Re: MySQL privileges problem

Can't you just give back root its privileges? Or were you logged in as root when you removed them? If so, maybe resetting the root password helps.


A bus station is where a bus stops.
A train station is where a train stops.
On my desk I have a workstation.

Offline

#3 2006-04-22 06:12:45

clank
Member
Registered: 2005-04-11
Posts: 35

Re: MySQL privileges problem

I can log back in as root, but the account has no administrative privileges anymore; create user, modify privileges, view process table, etc.


=> Now known as jb

Offline

#4 2006-04-22 23:19:07

Loke
Member
From: Denmark
Registered: 2005-10-21
Posts: 139

Re: MySQL privileges problem

clank wrote:

I can log back in as root, but the account has no administrative privileges anymore; create user, modify privileges, view process table, etc.

Maybe you can change the priviliges by running the mysql server in this way:
mysqld --skip-grant-tables --user=root

I've done that when I forgot root password, though I'm not sure if it works with the privileges stuff.

Offline

Board footer

Powered by FluxBB