MySQL
MysQl is a relational database management system that uses Structured Query Language (SQL).
This is the most popular language used on the internet for adding, accessing and processing data in a database which
when incorporated into a website can provide excellent dynamic content that is easy to update.
Selecting 'Databases' from the menu you can view any databases that are setup on your site, add, manage or delete them.
In the main window you will see any databases the are configured at the bottom with an option to edit or manage users next to each one.
To create a database choose a name and click 'add'.
You will see that siteworx will report back successful or not and you will see that the database you have just created will now be on the list at the bottom of the main window available for deletion or user management.
You will notice that the db name will be in the following format: sitename_dbname.
When you have a database set up you may want to change permissionsfor users on that database, this can be done by clicking manage users at the bottom of the main screen next to the database you would like to edit.
This will bring up a screen that shows what rights the user currently has in the way of checkboxes that are ticked. To add or remove permissions, tick or untick the boxes and click save.
Siteworx will report back.
To 'drop' or delete a database, just click the delete button that corresponds with the database you are looking to remove and press delete, Siteworx will ask for confirmation on the deletion, pressing delete will remove the database for good.
See Database edit
- SELECT: allows use of SELECT statements (i.e. data can be queried)
- DELETE: allows use of DELETE statements (i.e. data can be deleted)
- REFERENCES: not currently used by MySQL but reserved for future use
- INSERT: allows use of INSERT statements (i.e. data can be inserted into tables)
- CREATE: allows use of CREATE statements (i.e. tables can be created)
- INDEX: allows the creation and deletion of indexes
- UPDATE: allows use of UPDATE statement (i.e. data may be altered within a table)
- DROP: allows use of DROP statement (i.e. tables may be deleted/"dropped")
- ALTER: allows use of ALTER statement (i.e. table structures may be changed/altered).
(NOTE: The [check all] and [uncheck all] options provide a shortcut to checking individual permission checkboxes.)
If you have set up a database and select the manage users option without previously setting up a user, Siteworx will automatically create a user which is usually named domain_nickname, when going in to manage users you will see this user.
To set up more users or to choose the username (will always be sitename_username) you will need to create your them seperately.
To add a user, first select 'Users' from the menu under MySQL. In the main screen you will see the area where you will need to fill in the details of the user you would like to add with the button to add them. Underneath that will be a list of current users and what database(s) they have permissions on.
To edit a current user just click the 'Edit' button next to the user that you would like to edit. Here you will be able to change the password registered for this user. To change the permissions this user has you will need to look under MySQL > Databases and modifying permissions.
To delete a user just click the 'Delete' button next to the user that you would like to remove. Siteworx will ask you to confirm this, after clicking 'Delete' the user will be removed.
PhpMyAdmin is a popular, powerful web-based interface for administering MySQL databases. MySql is a command line driven database so people without knowledge of using shells and commands will benefit from this Graphical User Interface (Gui) that makes viewing and editing just a case of point and click. To login to PhpMyAdmin click on the PhpMyAdmin menu item or go the following address: https://www.YOURSITE.com:2443/mysql using the users that you have setup. (please note the user will only be able to see the databases that it has permissions on - to view all, log in through the control panel)
|
