The only two restrictions to creating are database are MySQL permissions and operating system restrictions. You should verify that your root privileges do indeed include permission to create a database (check for permission in the User table of the mysql database), and if you do, try creating a directory in your data folder while logged in as the mysql user.
For More Information
- Dozens more answers to tough MySQL questions from Mike Hillyer are available here.
- The Best MySQL Web Links: tips, tutorials, scripts, and more.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, MySQL, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in August 2004