Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
    
Have you done FLUSH PRIVILEGES; afterwards? –  sendmoreinfo Aug 22 '13 at 19:08

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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