KBase :: The Control Panel :: MYSQL databases

Information


Index

Creating a MYSQL database

Creating a user
Adding a user to a database
Removing a user from a database
Deleting a MYSQL database

 

With most account you will have the facility of creating MYSQL databases. These are used to hold large amount of information (such as this knowledge base you are using now)

Creating a MYSQL database
To create a MYSQL database you must first locate the MYSQL icon on the control panel and click it.

MYSQL databases

The following menu will then load.

 MYSQL databases

With this menu you can add/ remove both users and databases. To create a database you must first locate the dB text box, once you have done this enter the name of the database you wish to create and click on the Add dB button. You will then be told if your database creation was successful.

[Back To Index]

Creating a user
To enable a program/script to gain access to the database there must be a user name and password setup for it. To create a user name and password for a database you must first locate the MYSQL icon on the control panel and click it.

MYSQL databases

The following menu will then load.

 MYSQL databases

Halfway down this menu u will notice a USERS heading, under this heading there are two text boxes Username and Password. To create a user you must fill these in and click the add User button. You will then be told if the user creation was successful.

[Back To Index]

Adding a user to a database
Once a user has been created they can be added to a database. To add a user to a database you must first locate the MYSQL icon on the control panel and click it.

MYSQL databases

The following menu will then load.

 MYSQL databases

You can now add users to databases by clicking on the User drop down menu and selecting the user you wish to add, then click on the dB drop down menu and select the database you wish the user to be added to, then click the Add user to dB button. You will then be told if the user has been successfully added to your database.

[Back To Index]

Removing a user from a database
Just as users can be added to a database they can also be removed. You can do this by first clicking on the MYSQL databases icon within the control panel.

MYSQL databases

The menu much like following menu will then load.

 MYSQL databases

For this example we have used the database name testvdi_test. To remove a user from this database first locate the “Users in testvdi_test” heading then beneath this is the list of users associated with the database. Click on the delete button next to the user you wish to delete.



You will then be told if the user has been successfully removed from the database.

[Back To Index]

Deleting a MYSQL database
Just as you can add MYSQL databases you can remove them. To do this first click on the MYSQL databases icon within the control panel.

MYSQL databases

The menu much like following menu will then load.

 MYSQL databases

The databases that are contained on your account are then listed under the heading “databases” You can remove a database by clicking its delete button.



You will then be told if the database has been removed successfully.

[Back To Index]


 

Powered by KBase v1.0
© 2001 TLC Web Enterprises
All Rights Reserved
Timer: This page was generated in
0.0092 seconds.