Glossary    Contact Us
Search  
   
Browse by Category
Web Hosting help - HelpingHost.com .: Your Database .: MySQL .: Creating a MySQL Database and Its Users

Creating a MySQL Database and Its Users

To follow the steps below, you need to login to your hosting control panel first!

Please click here for a link to your hosting control Panel

 

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 MySQL DB creation Wizard automatically appears.
  2. On the form that shows enter the name of the database and database description if needed:

    NOTE:
    Starting from version 2.3.1, new MySQL databases are created with the username_ prefix, where username is a unique identifier that contains either first letters of the name of an account under which this database is created, or that account name's first letters and a unique number if there are several account names starting with the same letters. This is done to prevent the creation of databases with the same name under different users.

  3. Agree with additional charges if any.
  4. 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. User roles are explained below. Click Add user.
    • Choose roles for users of other databases so they can use your new database. Click Grant.

     
  5. Click Finish to complete creating your MySQL database.

How helpful was this article to you?

Related Articles

article Adding MySQL users and granting them privileges
(No rating)  March 6, 2004    Views: 1806   
article How do I backup my MySQL database?
(No rating)  September 24, 2004    Views: 1454   
article MySQL Database (Videos)
(No rating)  March 30, 2004    Views: 2048   

User Comments

Add Comment
No comments have been posted.


.: Powered by Lore 1.5.1
(c) HelpingHost.com 2002-2005