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

PhpMyAdmin – Administrate your MySQL database through a Web Interface

If you want to administrate your MySQL database, I strongly recommend you to use PHPMyAdmin. It is a Web interface that will allow you to run the most frequently used command through a very user friendly interface.


With that, you will not need to know anything about SQL language, you can just use the tool to do actions such as to create a database, export, import, backup, create user, gave additional permissions to some users, etc….


Obviously, before to install PHPMyAdmin to manage your MySQL databases, you need to install first MySQL Server:

Then install PHPMyAdmin by running:

It will ask you if you want to reconfigure your webserver. Select apache (with [SPACE] and then validate)

The next question will be to know if you want to configure database for phpmyadmin with dbconfig-common? ==> Not needed.

And that’s all.

You should have access to phpmyadmin from Your login is root and your password is the one you set during the installation of MySQL.

Example of configuration

Now let’s say you want to create a Database and a dedicated user to install WordPress on your computer.

1) Click on

2) In the “Create new database” field, set your DB name and click on “Create” button.


You should be informed that the database has been create


3) Now select “Check Privileges” at the right of the table you just created


4) And select “Add a new User”


5) Fulfill the needed information (User name, Host and password)


And select “Grant all privileges on database “myblog” to give this user full access to your database.

If you want to tune the access, simply select the permissions you want to give the user, from the list below.

6) Press to finish.

And now you are all set to configure your wordpress instance !


I know there are others alternatives to phpmyadmin, if you prefer some others, please share them in the comments for me to check them out.

Linux Apache MySQL PHP (LAMP) Server to host our own website

The most popular configuration to host our own website is certainly the Linux + Apache + MySQL + PHP combination (Alias LAMP server). Although it is possible to do the same using Windows (WAMP) or with others applications too, I will only focus on LAMP.

Apache is the most popular HTTP server; coupled with the world’s most popular Open Source database, MySQL and the very popular scripting language PHP, you should not doing a big mistake here using this combo.


To install it, just install all these applications:

During the installation, you will need to set MySQL root password and to select the Web Server to reconfigure (Apache in our case)



Either you want to build your own website from scratch or you could use some Content Management System (CMS), like WordPress, Drupal, or Joomla, which is like a template that you can customize and fulfil (Like this blog).

In any case, you will need to build a specific folder in /var/www, install what ever you want in it and provide a Virtualhost to inform Apache to deliver this folder depending on the url asked, as briefly discussed in my previous post to help you set a Static IP and explain the server/router should response.

Let’s say you want to host 2 websites, one blog and one photo gallery, here is how you should do:

1) Create the folders

(You can call the folders as you wish)

2) Add whatever CMS, services you want inside

3) Give proper permission to these folders

As we have created the 2 previous folders using sudo command, the owner is now root…which will cause access issues. To avoid that, we need to change the owner of these 2 folders by www-data.

chown is to change owner, -R option is for recursive, if you want to do it on full folder, you need to add -R, and www-data:www-data is to assign the folders to the user AND group www-data.

4) Create the needed virtualhost (Vhost) files

The apache virtualhost files are the key to know which folder/service to deliver when an user request a certain domain name.

For example, you may want that redirect to the folder /var/www/myblog and that the sub-domain redirect to /var/www/gallery or may be to have a second domain name directly, it’s in fact not very difficult with the Virtualhost.

You will need to create the conf file in /etc/apache2/site-available and then active this virtualhost (Actually you could directly create the conf file in /etc/apache2/site-enabled, thus already active but this solution is less flexible if you want to turn on/off sometimes some websites)

– Create the virtualhost:

In my presented case, the Virtualhost of that will redirect to the folder /var/www/myblog will look like (With comments after the ###, you could remove them if you want)

The remaining lines will not need much changes normally.

And you could do the same for your second website

– And now activate your 2 virtualhosts:

where myblog and gallery are the names of the virtualhost files created previously.

And finally restart apache:

If no error message, you should be all set.

PS: Don’t forget to create an A redirection on your domain name registrar to your IP and allow connection from port 80 into your router.

Exploits of a Mom