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.

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

1 Answer 1

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

 
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.