MySQL - Can't grant all privileges to myself
To make matters worse, the only way I can get into the database through localhost is with "/usr/bin/mysqld_safe –skip-grant-tables&" BUT the catch is with "--skip-grant-tables" I can't use the grant command.
Fortunately it's not a catastrophic problem because my application has all the permission it needs to run the website. But I need to get this fixed because sooner or later I'll need full access.
This doesn't work either:
mysql> create user root@localhost IDENTIFIED BY 'blah';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Any ideas?
3 Replies
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='me';
Now I can access the "mysql" table and I created a "root" user but I'm not sure I have full access yet.
grant all on *.* to root@localhost with grant option;
Query OK, 0 rows affected (0.12 sec)
I keep ketting 0 rows affected. Is that because these users already have full privileges?
Basically you can check with "show grants;" and "select * from user;" if you have full privileges.