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.
The following menu will then load.
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.
The following menu will then load.
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.
The following menu will then load.
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.
The menu much like following menu will then load.
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.
The menu much like following menu will then load.
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]
