Install MyWebSQL on Ubuntu 18.04?

Setting up a data server with MySQL or MariaDB is quite a simple task and we have done it many times in this blog. However, when we are on the client side, managing, editing and viewing the data stored in MySQL or MariaDB can be a cumbersome task. Fortunately, there are tools that can help us with that task. So, why today I will show you how to install MyWebSQL on Ubuntu 18.04.

MyWebSQL is an open source tool to manage data stored in MySQL or MariaDB. However, it is not only limited to them but is compatible with PostgreSQL and SQLite. Therefore, we are in the presence of an essential tool on the client side.

So, let us install MyWebSQL on Ubuntu 18.04.

1. Install Apache web server and PHP

First, it is necessary to install a web server. Therefore, I will install the Apache Web server. It is simple, free and it is available in the official Ubuntu repositories, so everything will be faster.

:~$ sudo apt install apache2

Once the installation has finished, the service will start automatically. However, if you want Apache to run at system startup, run the following command:

:~$ sudo systemctl enable apache2

After that, you need to install PHP, some of their modules and other necessary packages.

:~$ sudo apt install php libapache2-mod-php php php-common php-mbstring php-gd php-intl php-curl php-xml php-mysql php-pgsql php-mysql php-bcmath unzip wget

Verify the installed PHP version with the following command.

:~$ php -v

Then, it is a good idea to test the Apache and PHP installation. To do it, create a new file called test.php on the /var/www/html/ folder.

:~$ sudo nano /var/www/html/test.php

Now, add the following:

<?php
phpinfo();
?>

Press CTRL + O to save the changes and CTRL + X to close the editor.

After that, restart the Apache web server service.

:~$ sudo systemctl restart apache2

Finally, open your web browser and go to http://SERVER_IP/test.php.

If the PHP information is shown in the browser as in the previous image. Then everything is fine.

2.- Install a Database manager

As I said before, MyWebSQL is compatible with several database handlers. In this section, you can install the one you want. However, for this example, I will use MySQL which is perfectly compatible with MyWebSQL so let’s go for it.

:~$ sudo apt install mysql-server

Now, it is time to set a new root password for MySQL. You can do it using the mysql_secure_installation script.

:~$ sudo mysql_secure_installation

Now, answer the question like the following way:

Change root password? Y
Remove anonymous users? Y
Disallow root login remotely? Y
Remove test database and access to it?  Y
Reload privilege tables now?  Y

So, that is all for MySQL.

Next, create a new user for MyWebSQL. You can use the user and password you want.

:~$ sudo mysql -u root -p
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO 'angelo'@'localhost' IDENTIFIED BY 'Angelo12.,';
FLUSH PRIVILEGES;
exit;

3. Install MyWebSQL on Ubuntu 18.04

now it’s time has come to install MyWebSQL, first, you need to download it. For now, the last stable version of the program is 3.7. So, run this command:

:~$ wget https://newcontinuum.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.7.zip

Next, decompress it on the Apache root folder.

:~$ sudo unzip mywebsql-3.7.zip -d /var/www/html

After that, set the correct permissions.

:~$ sudo chown -R www-data:www-data /var/www/html/mywebsql/
:~$ sudo chmod -R 775 /var/www/html/mywebsql/

Now, complete the installation from the web interface. Open the web browser and go to http://SERVER_IP/mywebsql/install.php

After that, access to the MariaDB instance using the right credentials.

Then, you will see the main screen of the application.

So, that is it.

Conclusion

MyWebSQL is a great help tool for data management using MySQL, MariaDB, PostgreSQL or SQLite. It’s a great alternative to PHPMyAdmin and honestly, I like it better.

You can also read our post about installing MyWebSQL on CentOS 7.

Please share this post with your friends.