0

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?

Zypher
  • 37,405
  • 5
  • 53
  • 95
Ben
  • 775
  • 4
  • 9
  • 19

1 Answers1

1

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.

Marco Ramos
  • 3,120
  • 23
  • 25