Customer Care & Support
Flash TutorialOnline
Flash Tutorials
.
Moving / Transferring from other Web Host.
Download Dominios Latinos User Documentation.
Online User Guide.
Frequently Asked Questions (FAQ)

Hosting Control Panel
     Login
Domain Name
 
     Password
User Password  
                                

Control Panel Documentation User Guide Menu download ultimateircd winxp

 

Hosting MySQL Databases
download ultimateircd winxp

 

Related Docs:  download ultimateircd winxp

Hosting Microsoft SQL Databases Hosting PostgreSQL Databases download ultimateircd winxp

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.

 download ultimateircd winxp

Creating MySQL Database and Its Usersdownload ultimateircd winxp

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

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

However, MySQL users can be shared by different databases.download ultimateircd winxp

To create a MySQL database, do the following:download ultimateircd winxp

  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:

    download ultimateircd winxp

  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:
  5. download ultimateircd winxp

    • 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.

 download ultimateircd winxp 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. Select MySQL DBs in the Databases menu.
  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. download ultimateircd winxp

  4. In the form that appears, click Built in phpMyAdmin control panel to start editing your database:

    download ultimateircd winxp

  5. Follow the instructions of the phpMyAdmin control panel to edit your MySQL DB.

 download ultimateircd winxp

Changing MySQL disk quota.download ultimateircd winxp

MySQL disk quota is the maximum allowed size of one MySQL database. If you exceed this quota, you'll be charged for overlimit at a different (usually higher) price.download ultimateircd winxp

To change MySQL disk quota, do the following:download ultimateircd winxp

  1. Select MySQL DBs in the Databases menu.
  2. Click the MySQL Database or the Edit icon on its right:
  3. Click the Change button against the Quota field:

    download ultimateircd winxp

  4. Enter the new quota.
  5. Click Submit.
  6. Agree to additional charges.

 download ultimateircd winxp

Changing user passwords.download ultimateircd winxp

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

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

 download ultimateircd winxp

Adding MySQL users and granting them privileges.download ultimateircd winxp

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

  1. Select MySQL DBs in the Databases menu.
  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:

    download ultimateircd winxp Each user role involves a fixed set of privileges on this specific database:

    download ultimateircd winxp
    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 and agree to additional charges.
  6. To edit privileges, click the Edit icon next to the user. You will be brought to the Privilege Maintenance page.
  7. download ultimateircd winxp

  8. 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.download ultimateircd winxp

 download ultimateircd winxp


Related Docs:  download ultimateircd winxp

Hosting Microsoft SQL Databases Hosting PostgreSQL Databases download ultimateircd winxp


.info .biz .us .org .tm .cc .cn .net


Internet Content® Rating Association WS Ftp Nico Ftp
Dominios Latinos LLC. All rights reserved
Copyright @ 1999 - 2011
libretabierta.com