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

Hi I have probem with phpmyadmin on ubuntu (My desktop computer): cant create new database with phpmyadmin its writes: no privileges. How privaleges can be enable that i will able to create new database? Thanks

I try your solution and I get this result on console:

The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

What should I do?

share|improve this question
up vote 1 down vote accepted

Probably, the mysql user that you're using with phpmyadmin does not have the Create_priv privilege (probably does not have other privileges that you'll want to use, either).

Try to set it like this:

GRANT CREATE ON yourdb.* TO 'someuser'@'somehost';

More on Grant syntax here.

share|improve this answer

Your Answer


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.