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

Somehow one of my MySQL servers is configured in a way that users can't create Databases named 'test_foo' anymore. I would like to restore the default rules that come with fresh MySQL installations because I need test_ databases for a test suite my application wants to run.

share|improve this question
up vote 0 down vote accepted

Got it: Running/usr/bin/mysql_install_db fixed the default permissions. However, it also seems to have destroyed some other privileges - I had to grant them again, so use this with caution (and good backups)

share|improve this answer
This is a workaround, but not a good enough solution. I have many permissions already set, and I don't want to lose all of them. – Denilson Sá Oct 22 '10 at 20:02

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.