Home / server / Questions / 142996
Accepted
Ben
Asked: 2010-05-19 06:02:32 +0800 CST

Ubuntu--cant create new database with phpmyadmin its writes: no privileges

  • 772

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?

ubuntu lamp users

1 Answers

  1. Best Answer

    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.

    • 1