Skip to main content

MyWebSQL, Web based Database Administration panel

Last month I presented Adminer, an alternative to PhpMyAdmin, and received a good comment from Kristin, recommending MyWebSQL for its simple interface.

I didn’t know this software and was glad to discover it.

MywebSQL main page screenshot

MyWebSQL is a web based administration panel for MySQL SQLite and PostgreSQL. Opensource and written in PHP, MyWebSQL is easy to deploy and manage while having good performance and developer friendly.

create database mywebsql

Indeed, with a look of desktop based application (right click menus, options and dialogs) while having a WYSIWYG table and query editor with syntax highlighting, MyWebSQL is a robust alternative to PHPMyAdmin.

table editor mywebsql

You can check their highlighted list of features here and give directly a try there.

Interested? Let’s see how to install it!


I will assume you have a Apache, MySQL and PHP configuration. If not, please check my previous tutorial covering the installation of these softwares.

1) Download and extract the latest version in your /var/www

2) Set the web server user, the owner of your mywebsql folder to ensure proper permission

And you’re on!

Simply go to http://YourIP/mywebsql to access to the adminstration panel.

MyWebSQL login page

Enter your MySQL credentials to manage your database(s).

If you want to customize MyWebSQL and tweak its config files, everything is inside the folder /var/www/mywebsql/config and should be quite self explanatory thanks to dev’s comments.

Although not mandatory, I strongly recommend you to force HTTPS connections to secure your MyWebSQL instance. Meanwhile you could also prefer to have a dedicated domain name instead of using the full URL and increase the maximum PHP upload file size limit (default 2mb). Either way, you can do all that through a dedicated virtualhost, and here is how to:


Virtualhost configuration

What you will need:

1) Create a A redirection in your DNS server/registrar with something like sql.domain.tld to your IP

2) Have SSL certificate ready. If not you can read this tutorial. (Optional)

3) Create your virtualhost as following:

In /etc/apache2/sites-enabled/, create a file called mywebsql (In root):

and paste the following content:

Adapt the content (Servername, webmaster email, SSL certificate, directory and php values).

When done, save the file (CTRL+X then Yes) and reload apache: (In root)

You should now be able to access to your MyWebSQL instance through sql.domain.tld.  It should automatically redirect your to its HTTPS version and you should be able to upload/import files up to 20Mb.



sql query analysis

PHP database management tool – Adminer, the alternative to PHPMyAdmin

adminer database management logo

If you think PHPMyAdmin is too heavy for your server, or wish to have a proper web administration tool for your  databases, Adminer is one of the few alternative projects to PHPMyAdmin, that is still under active development.

Indeed, Adminer (formerly known as phpMinAdmin) is a full-featured database management tool written in PHP. The installation is very easy (Single file) while yet powerful enough to support extensive set of databases, such as MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch and also MongoDB.

Available in many languages, Adminer have 5 key development priorities. That are:

1. Security,

2. User experience,

3. Great performance,

4. Large feature set,

5. Compact size.

They actually claim to superior in many ways to PHPMyAdmin and you can check their comparison here. Although you may not agree with all their claims, Adminer can be highly customized and is indeed very easy to install (Through your distribution repo or simply by downloading their latest version, available as a single php file!!)

Adminer - Main page screenshot

You can directly check their online demo to give it a try.

And as usual, here is how to install it on your server:


– Installation from your distribution repo:

You can simply install Adminer from the repositories of your distribution. In my case, on Debian 7, I can get the version 3.3.3-1 and to install it, I simply need to run (as root or using sudo)

And you will be able to directly access the web interface through http://YourIP/adminer

– Latest version from the official website

But if you prefer to use the latest version, the installation is still very easy! Only 1 file to donwload.

In your /var/www, you can simply download adminer php’s file. For the v4.1.0, in my case, I will run:

and then I will have directly access to the adminer web interface through http://myIP/adminer-4.1.0.phpAdminer - LoginEasy to install right?