You are not logged in.
- Topics: Active | Unanswered
#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
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