MySQL

InterWorx provides easy management of the MySQL database application on the server.

The NodeWorx user has access to editing the following general settings of the MySQL database server:

• Start, Stop, or Restart the MySQL daemon
• Toggle: Start MySQL on bootup? Yes/No
• Toggle: Auto Restart MySQL Yes/No (System Integrity Monitor --SIM)
• View Current MySQL Version
• Toggle: MySQL RRD Graphs On/Off
• General MySQL Options: Connections (max), Connection Errors (max), Connect Timeout, Wait Timeout, Key Buffer Size, Sort Buffer Size, Read Buffer Size, Maximum Allowed Packet Size, Thread Cache Size, Table Cache, Query Cache Limit, Query Cache Size.
• Reset MySQL Root Password
• View all current MySQL processes
• Kill any current MySQL process

SiteWorx users can create or delete as many databases as allowed in their quota as specified by the system administrator or reseller.

SiteWorx users can create or delete as many database users as allowed in their quota as specified by the system administrator or reseller. The website administrator has “at a glance” access to what databases and users exist and what users have perms on what databases.

The website administrator may wish to create one user and grant it access to all databases, or assign each database it’s own separate user (and password) for security reasons. Each additional database MUST be manually assigned a user and permissions upon creation.

The Database user can be assigned as many or as few of the following permissions as desired:

Both SiteWorx and NodeWorx have the phpMyAdmin database management utility integrated. From it’s simple web interface the website administrator can manipulate all of the databases assigned to it. The system administrator can manipulate any database on the system.

More about phpMyAdmin

• http://www.phpmyadmin.net