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.
Asked
Active
Viewed 478 times
1 Answers
0
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)
c089
- 121
-
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á Maia Oct 22 '10 at 20:02