Mysql – Privileges issue

MySQL

I have a mysql database (version 5.5), and I am trying to add a new user.
But I don't have the privileges to create it.If I try to show the list of all users:

select * from mysql.user;

It gives this error:

ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'user

It seems like I am not able to do anything.How to grant the privileges for a user without using the grant command?
There's a way? I also tried this:

CREATE USER 'ramy'@'localhost' IDENTIFIED BY 'pass';

It says:

ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation

I don't see any way to handle privileges, mysql show have a method to handle privileges for who have newly created a database.That's a vicious circle.

Best Answer

You need to login as the 'root' account

See this if you don't know the root password

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Related Solutions

Mysql – ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’

yes this bug is there. However, I found a small workaround.

Assume the user is there, so drop the user
After deleting the user, there is need to flush the mysql privileges
Now create the user.

That should solve it. Assuming we want to create the user admin @ localhost, these would be the commands:

drop user admin@localhost;
flush privileges;
create user admin@localhost identified by 'admins_password'

Cheers

Mysql – Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How to grant privileges

I also had the same problem with this but on Windows after upgrading to MySQL 5.5 from MySQL 5.1. I already tried changing, creating, and resetting password mentioned in here, here, here, and here, no clue. I still get the same error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I'm able to connect normally, show all databases, do selects and inserts, create and add users, and but when it comes to GRANT, I'm screwed up. Those access denied error shows up again.

I managed to solve this problem by fixing the privileges by the following command on the MySQL server bin/ directory as mentioned in here:

C:\MySQL Server 5.5\bin> mysql_upgrade

Then, the problem gone away. I hope this solution works on Linux too since usually MySQL provide the same command both on Linux and Windows.

Best Answer

Related Solutions

Mysql – ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’

Mysql – Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How to grant privileges

Related Topic