System Services : MySQL Server
==============================

**System Services > MySQL Server**

This menu section in NodeWorx is where Server Administrators can manage system MySQL settings, 
remote MySQL servers, and access PHPMyAdmin.

InterWorx utilizes two different MySQL instances--there is the system MySQL instance that is used for domain-level
MySQL processes and sessions, and also an internal MySQL instance specifically for the InterWorx software. 
This allows users to install any server-level version of MySQL that they would like, as long as it is a newer
version that what is already installed on the server, without risk of 
affecting the InterWorx software. 

The menu options under MySQL Server manage the system MySQL instance. 

Manual changes to the internal InterWorx database should only be performed InterWorx Support Technicians. 

Technically speaking, InterWorx Support does not directly support the server MySQL instance, though 
they will try to guide in the correct direction, if contacted.

While many tasks related to MySQL can be completed via the GUI, there are many others that require
configuration at the CLI, such as creating non-prefixed databases assigned to a specific SiteWorx 
account, or changing the database server for a SiteWorx account. 

Documentation on managing MySQL with InterWorx can be found :doc:`here </nodeworx/mysql_server/index>`.

Logging related to the system MySQL service can generally be found in the ``/var/log/mysql/`` or 
``/var/log/mariadb/`` directories. If those directories do not exist on the server, logging related 
to MySQL will be found in  the ``/var/log/messages`` log file. 

.. contents::

Overview
--------

**System Services > MySQL Server > Overview**

.. image:: /images/nw101-mysql-overview.png
   :alt: mysql overview page
   :class: float-right

From the OverView page, Server Administrators can easily manage: 

- The status of the server MySQL service
- MySQL server options
- The MySQL root password
- Current MySQL processes

Documentation on managing the server MySQL instance can be found :doc:`here </nodeworx/mysql_server/configure-mysql-options-nodeworx>`.

.. rst-class::  clear-both

Manage Servers
--------------

**System Services > MySQL Server > Manage Servers**

.. image:: /images/nw101-mysql-servers.png
   :alt: mysql manage servers page
   :class: float-right
   
From the Manage Servers page, Server Administrators can easily manage: 

- Adding and deleting remote MySQL servers
- Checking the status of both remote MySQL server and the localhost MySQL instance
- Unmapped MySQL databases and users

External, remote MySQL servers do not need to have InterWorx installed. 

Documentation on managing MySQL servers can be found :doc:`here </nodeworx/mysql_server/mysql-server-pooling-guide>`.

.. rst-class::  clear-both

PHPMyAdmin
----------

**System Services > MySQL Server > PHPMyAdmin**

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

Using PHPMyAdmin, Server Administrators can easily: 

- Manage customer MySQL databases 
- Manually create new databases 
- Manage system MySQL user settings 
- Import and export database backups in various formats

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