Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Installed ZPanel on CentOS 6. Created user, added database. But user has no privileges.

Tried to create in SQL shell with

GRANT ALL PRIVILEGES ON db_name.* To 'name'@'localhost' IDENTIFIED BY 'xxxxxxx';

get #1044 - Access denied for user 'name'@'%' to database 'db_name'

What need to do to grant privileges?

share|improve this question

closed as off-topic by Ward, MadHatter, Jim B, HopelessN00b, mdpc Feb 25 at 22:37

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

    
Have you done FLUSH PRIVILEGES; afterwards? – sendmoreinfo Aug 22 '13 at 19:08
up vote 0 down vote accepted

You would have to login with the root account to do this. If you created a user call it jsmith and are trying to create another user account jdoe, you must first login with root to give jsmith grant rights. The question is who are you logged in as right now running this command?

share|improve this answer
    
Yes, you are right. Logged in as root user and can change privileges etc. I was logged in as another user, created at ZPanel – user2118559 Aug 23 '13 at 4:56

Not the answer you're looking for? Browse other questions tagged or ask your own question.