https://wiki.uniformserver.com/index.php?title=Z_controller_MySQL_Tab&feed=atom&action=historyZ controller MySQL Tab - Revision history2024-03-28T21:15:54ZRevision history for this page on the wikiMediaWiki 1.41.0https://wiki.uniformserver.com/index.php?title=Z_controller_MySQL_Tab&diff=4177&oldid=prevRic: New page: {{Nav z controller}} '''MySQL Tab''' Installing third party applications that use the MySQL server is easy. Uniform Server places no restrictions and allows you to install using the root ...2010-03-28T12:48:14Z<p>New page: {{Nav z controller}} '''MySQL Tab''' Installing third party applications that use the MySQL server is easy. Uniform Server places no restrictions and allows you to install using the root ...</p>
<p><b>New page</b></p><div>{{Nav z controller}}<br />
'''MySQL Tab'''<br />
<br />
Installing third party applications that use the MySQL server is easy. Uniform Server places no restrictions and allows you to install using the root user account..<br />
<br />
For a test server this is fine however for a production server it is already compromised! The root user is known, both name and password is set to root.<br />
<br />
As a first line of defence you must change the MySQL root user password using Apanel. You can install all applications using this root user and new password.<br />
<br />
For a production server using the root user account even with a new password is high risk. Should this root user account become compromised a malious user can delete all databases and data. The root user is all-powerful and can run any task on the MySQL server.<br />
<br />
After installing an application create a restricted user on the MySQL server and edit the application’s configuration file. Replacing the root user with this restricted user account.<br />
<br />
Every application shall have a unique restricted user. If this user becomes compromised hopefully any damage is confined only to that application.<br />
<br />
'''''[[#top | Top]]'''''<br />
== Restricted user ==<br />
A restricted user has a unique name and password with minimum privileges assigned to a specific database. This user has no global privileges further restricting server access. <br />
<br />
Assign only minimum privileges required for the application to run.<br />
<br />
Privileges: SELECT, INSERT, UPDATE, DELETE<br />
<br />
These privileges are referring what that user can perform on tables within that database assigned. For example assign the first three these are safe only assign delete if required by a n application.<br />
<br />
'''''[[#top | Top]]'''''<br />
== Use phpMyAdmin ==<br />
Using phpMyAdmin to create a restricted user is covered on the [[MySQL Security | '''MySQL Security''']] page.<br />
<br />
It’s worth reading to appreciate the convenience of using the MySQL tab<br />
<br />
'''''[[#top | Top]]'''''<br />
== MySQL Tab ==<br />
{|<br />
|- valign="top"<br />
|<br />
=== MySQL Tab intro ===<br />
The MySQL tab was added in V56_ZCON_1_1 it contains three buttons you generally use in the following order.<br />
* '''''Add or Delete Database''''' When installing an application you can use this button to create a database. Alternatively you can delete a database.<br />
* '''''Add restricted user''''' For a production server you creates a restricted user and assign a database to that user.<br />
* '''''Edit User''''' Use this button to edit a restricted user it allows you to change a user's privileges.<br />
<br />
Each button opens a pop-up window as shown below.<br />
|<br />
[[Image:MySQL_tab.gif]]<br />
<br />
|- valign="top"<br />
|<br />
<br />
=== Add or Delete Database ===<br />
This pop-up window allows you to create or delete a database. <br />
<br />
'''''Create a database'':'''<br />
* Enter a database name in the text window<br />
* Press Create Database button<br />
* Database is created and listed in the list window.<br />
<br />
'''''Delete a database'':''' <br />
* From the list of databases select a database to delete<br />
* Click Delete Database button<br />
* Database is deleted and removed from list window.<br />
|<br />
[[Image:MySQL_tab_1.gif]]<br />
<br />
|- valign="top"<br />
|<br />
<br />
=== Add restricted user ===<br />
To creating a restricted user fill in the form<br />
* Enter a user name<br />
* Enter a user password<br />
* Either enter a database name or select one from the list<br />
* On the right check or uncheck privileges you want to assign to this user<br />
* Click Create User button.<br />
<br />
'''''Note 1'':''' If user exists you will be requested to enter a new user. A User must be unique.<br />
<br />
'''''Note 2'':''' If a database does not exist you can still assign it to a user and create the database later.<br />
|<br />
[[Image:MySQL_tab_2.gif]]<br />
<br />
|- valign="top"<br />
|<br />
<br />
=== Edit User ===<br />
This pop-up allows you to change a restricted users password and privileges.<br />
<br />
'''''Select User'':'''<br />
* Select a user to edit from the list of users.<br />
* With the exception of password users current settings are filled in<br />
* Delete button is enabled<br />
'''''Delete User'':'''<br />
* Click Delete Butoon to remove this user.<br />
* User is deleted and removed from list<br />
'''''Update User'':'''<br />
* Check or uncheck privileges you wish to change<br />
* Either enter old password or enter a new password for this user.<br />
* Click Update User button <br />
|<br />
[[Image:MySQL_tab_3.gif]]<br />
|}<br />
'''''[[#top | Top]]'''''<br />
<br />
== Summary ==<br />
Tabs group functionality and expose Uniform Servers’s features.<br />
<br />
Main drop down menus take a slightly different approach generally they target a single feature by name. However a pop-up window that opens as a result of a selection may contain a common group of related features.<br />
<br />
Each drop down menu is covered on a separate page they have an identical name as the menu.<br />
<br />
First menu to be covered is the [[Z controller File | '''File menu''']].<br />
<br />
'''''[[#top | Top]]'''''<br />
<br />
----<br />
<br />
[[Category: Uniform Server 5.0-Nano]]</div>Ric