SQL commands in Webmin

From Swivel Knowledgebase
Revision as of 12:52, 11 May 2017 by Admin (talk | contribs) (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


Overview

This document illustrates how to execute SQL Commands through the Webmin appliance feature. For a list of MySQL commands see MySQL Queries How To Guide.

Login to Webmin

For information on logging into Webmin and troubleshooting information, see the Webmin How To Guide.


Access the MySQL Database Webmin Module

You can access the MySQL component of Webmin by clicking Servers -> MySQL Database Server:

Webmin mysql.png


Select the database to work with

From the MySQL screen you can access the pinsafe_rep database to perform queries against it:

Webmin mysql screen.PNG


View the tables within the selected database

After selecting the database you want to work with (usually pinsafe_rep), you can view the tables within the database:

PINsafe Appliance Webmin Edit Database.jpg


Executing SQL commands

From the above screen you can click on the Execute SQL button. You will then be taken to a screen where you can enter an SQL command:

PINsafe Appliance Webmin Execute SQL.jpg


Enter the SQL query into the text box then click on Execute:

PINsafe Appliance Webmin Execute SQL data.jpg


The output will be displayed:

PINsafe Appliance Webmin Execute SQL data output.jpg