Angelo
Angelo
I am Angelo. A systems engineer passionate about Linux and all open-source software. Although here I'm just another member of the family.

How to install MyWebSQL on Ubuntu 20.04?

Hello, friends. Today, you will learn how to install MyWebSQL on Ubuntu 20.04.

MyWebSQL is a web application created with PHP that allows us to manage an instance of MariaDB / MySQL, PostgreSQL or SQLite.

Being compatible with these tools can be of great help in many projects.

So, with MyWebSQL you can create, modify and delete data, tables, and databases all from a comfortable web interface. Let’s get started.

Install MyWebSQL on Ubuntu 20.04

Install Apache and PHP

Since this is a web tool created with PHP, we have to install these two components.

Open a terminal or SSH session and refresh the system.

sudo apt update
sudo apt upgrade

Then install Apache

sudo apt install apache

Next, install PHP, its modules and also the unzip package needed for our post.

sudo apt install php7.4 libapache2-mod-php7.4 php7.4-json php7.4-common php7.4-gmp php7.4-curl php7.4-mysql php7.4-pgsql php7.4-pgsql php7. 4-sqlite3 php7.4-intl php7.4-mbstring php7.4-xmlrpc php7.4-gd php7.4-cli php7.4-bcmath php7.4-xml php7.4-zip php7.4-imap unzip php7.4-imap unzip

Remember that in your firewall, you have to open ports 80 and 443 for Apache access.

Then apply the changes by restarting the Apache service.

Install MariaDB

In this post, we will use MariaDB to demonstrate the installation of MyWebSQL but in this step you can install PostgreSQL or SQLite and you can still take advantage of the application.

So, install MariaDB sudo apt install mariadb-server Then, change the root user’s password by using the command

sudo mysql_secure_installation

After changing the password, you will be asked a few confirmation questions that you must answer Y.

Now create a new database that will serve as a starting point for using MyWebSQL.

So, access the MariaDB shell.

sudo mysql -u root -p

Create the database with the name you consider correct.

CREATE DATABASE websqldb;

Then, a user different from the root user. Call it whatever you want, and set a secure password.

CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';

Grant permissions on the new database.

GRANT ALL ON websqldb.* TO 'user'@'localhost' WITH GRANT OPTION;

Refresh permissions.

FLUSH PRIVILEGES;

Finally, exit the shell

exit;

Download MyWebSQL on Ubuntu 20.04

Create a folder to host MyWebSQL in the Apache web directory.

sudo mkdir /var/www/html/mywebsql/

Then download the latest version available. At the time of writing this post, it is 3.8.

wget https://liquidtelecom.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.8.zip -O mywebsql.zip
1.- Download MyWebSQL on Ubuntu 20.04
1.- Download MyWebSQL on Ubuntu 20.04

Now unzip the file.

sudo unzip mywebsql.zip 

Move the contents of the folder to the created folder.

sudo mv mywebsql/* /var/www/html/mywebsql

Make Apache the owner of the folder,

sudo chown -R www-data:www-data /var/www/html/mywebsql/

And give it the necessary permissions

sudo chmod -R 755 /var/www/html/mywebsql/

The next step is to create a new Virtual Host for Apache to better manage the MyWebSQL site.

sudo nano /etc/apache2/sites-available/mywebsql.conf

And add the following

<VirtualHost *:80>
    ServerAdmin admin@example.com
    DocumentRoot /var/www/html/mywebsql
    ServerName domain

    <Directory /var/www/html/mywebsql>
        Options FollowSymlinks
        AllowOverride All
        Require all granted
    </Directory>

    ErrorLog ${APACHE_LOG_DIR}/example.com_error.log
    CustomLog ${APACHE_LOG_DIR}/example.com_access.log combined
</VirtualHost>
2.- Virtualhost for MywebSQL
2.- Virtualhost for MywebSQL

Replace the ServerName value with your domain. Save the changes and close the editor.

Enable the new configuration

sudo a2ensite mywebsql.conf

And the rewrite module

sudo a2enmod rewrite

Finally, apply all changes by restarting Apache.

sudo systemctl restart apache2

You are done.

Access to MyWebSQL

It is recommended to take a look at http://your-domain/install.php this file shows if the server meets the requirements. If it does, you can exit the page and delete it.

sudo rm /var/www/html/mywebsql/install.php

And go to http://your-domain to see the login page.

3.- MyWebSQL login screen
3.- MyWebSQL login screen

Log in with the credentials created for the new user, and finally, you will see the following image.

4.- MyWebSQL on Ubuntu 20.04
4.- MyWebSQL on Ubuntu 20.04

So, enjoy it.

Conclusion

MyWebSQL is a very useful tool for architects. In this post, you have learned how to install it on Ubuntu 20.04. Thank you.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest articles

Join us on Facebook

x