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.

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

1 Answer 1

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

 
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.