Hosting Features: MySQL
=======================

**Hosting Features > MySQL**

This menu section in SiteWorx is where SiteWorx users can manage their account's MySQL databases and users, 
as well as access PHPMyAdmin. 

NodeWorx users have the ability to determine the number MySQL databases and users the SiteWorx account is 
allowed to have. These options are managed via the Edit menu located in NodeWorx, 
under **SiteWorx > Accounts**. If these options are to 0, the associated menu 
items, including PHPMyAdmin, will not appear in the SiteWorx interface.

Documentation related to managing MySQL in SiteWorx can be found :doc:`here </siteworx/mysql/index>`.

.. contents::

Databases
---------

**Hosting Features > MySQL > Databases**

.. image:: /images/sw-mysql-databases.png
   :alt: databases page
   :class: float-right

The Databases page is where SiteWorx users can: 

- Manage MySQL databases
- Assign MySQL users to specific databases

Information on managing MySQL databases can be found :doc:`here </siteworx/mysql/database-guide>`.

.. rst-class::  clear-both

Users
-----

**Hosting Features > MySQL > Users**

.. image:: /images/sw-mysql-users.png
   :alt: mysql users page
   :class: float-right

The Users page is where SiteWorx users can manage MySQL users. 

Assigning MySQL users to a specific database is managed from the Databases page.

Information on managing MySQL users can be found :doc:`here </siteworx/mysql/add-edit-delete-mysql-users>`.

.. rst-class::  clear-both

PHPMyAdmin
----------

**Hosting Features > MySQL > PHPMyAdmin**

.. image:: /images/sw-phpmyadmin.png
   :alt: phpmyadmin
   :class: float-right

PHPMyAdmin is a GUI interface for MySQL databases. This allows users the ability to easily manage their 
database tables and content.

Documentation on how to use PHPMyAdmin can be found at `https://www.phpmyadmin.net/docs/ <https://www.phpmyadmin.net/docs/>`__.

Information on accessing PHPMyAdmin can be found :doc:`here </siteworx/mysql/log-phpmyadmin>`.