How do I create a MySQL Database?   (published: 6/18/2003 3:40:09 PM)
Article # 186
Title How do I create a MySQL Database?

MySQL users cannot exist separately from MySQL databases. You must stick to the following sequence:

  1. Create a database
  2. Add MySQL users to each created database.

However, MySQL users can be shared by different databases.

To create a MySQL database, do the following:

  1. Select MySQL in the Databases menu and a MySQL DB creation Wizard automatically appears.
  2. On the form that shows enter the name of the database and database description if needed:
     

    3.  In the form that appears, create a new user or grant privileges to users of other databases:

    • Add a new user to the database you have just created.  Click Add user.
    • Choose roles for users of other databases so they can use your new database. Click Grant
       

   4.   Click Finish to complete creating your MySQL database.

More Information
Related information
Related download(s)
Did you find this useful?  [rate this article]
This article has been viewed 292 times
Average reader rating 0 out of 10

©2003 NetFronts Inc.