Zanyspace.com - Web Hosting for Ambitious Websites
HomeWeb HostingDomainsWeb DesignQuick GuideContact Us
Hosting MySQL Databases

Related Docs:  

Hosting PostgreSQL Databases

MySQL is a database management system. It allows you to add, access, and process stored data. The SQL part of MySQL stands for "Structured Query Language" - the most common standardized language used to access databases.

 Creating MySQL Database and Its Users

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. Click MySQL Server on your control panel home page.
  2. Click Add database at the bottom of the form:
  3. On the form that shows enter the name of the database and database description if needed:
  4. Agree with additional charges if any.
  5. 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.
6. Click Finish to complete creating your MySQL database.
 Editing MySQL databases (phpMyAdmin)

You can edit the content of your databases using the phpMyAdmin utility that comes with your control panel. To run phpMyAdmin, do the following:

  1. Click MySQL Server on your control panel home page.
  2. In the form that appears, click the name of the existing MySQL Database you want to edit or the Edit icon on its right:
  3. In the form that appears, click Built in phpMyAdmin control panel to start editing your database:
  4. Follow the instructions of the phpMyAdmin control panel to edit your MySQL DB.

 Changing user passwords.

To change user password in the MySQL database, do the following:

  1. Click the MySQL Database
  2. .
  3. In the form that appears (see above), click the Change password icon next to the DB user.

 

Adding MySQL users and granting them privileges.

Here you will learn how to add new users to an existing MySQL database.

  1. Click MySQL Server on your control panel home page.
  2. Click the MySQL Database or the Edit icon on its right:
  3. On the form that shows, click the Add icon against the Database users field.
  4. Fill the following form:

    Each user role involves a fixed set of privileges on this specific database:
    Role: Set of privileges:
    read select
    read/write select, insert, delete, update
    dba select, insert, update, drop, create, alter, index
  5. Click the Add or Grant button
  6. To edit privileges, click the Edit icon next to the user. You will be brought to the Privilege Maintenance page.
  7. Check or uncheck the desired privileges and press the Submit button.

Note:For more information on MySQL access privileges, please refer to www.mysql.com.
IMPORTANT: any changes in user privileges will be applied to the whole selected database.


Related Docs:  

Hosting PostgreSQL Databases


Secure your domain name today with Zanynames.
.

Fast & friendly assistance with your ambition
Get Help Now

Login
Password


If you have forgotten your password, click here.


May 100.00%
April 100.00%
March 100.00%
Full Report
© 2003 - 2004 Zanyspace | Our Clients | Terms of Service | All prices displayed on this page are in U.S Dollars unless stated