Atlantic.Net Blog

How to Install MyWebSQL on Oracle Linux 8

MyWebSQL is a modern web-based application for database administration over the web. It is a free and open-source MySQL database client written in PHP. MyWebSQL supports several databases, including MySQL, PostgreSQL, and SQLite. It is simple, fast, easy to use, and can be used to perform all database-related operations. MyWebSQL is compatible with all major web browsers and allows you to edit and delete multiple records at the same time.

In this tutorial, we will show you how to install MyWebSQL on Oracle Linux 8.

Step 1 – Install Apache, MariaDB, and PHP

First, you will need to install the Apache web server, MariaDB server, PHP, and other required modules in your system. You can install all of them by running the following command:

dnf update -y
dnf install httpd mariadb-server php php-cli php-mysqlnd php-fpm php-zip php-devel php-gd php-mbstring php-curl php-xml php-pear php-bcmath php-json unzip curl wget -y

After installing all the packages, start the Apache and MariaDB services and enable them to start at system reboot:

systemctl start httpd php-fpm
systemctl start mariadb
systemctl enable httpd php-fpm
systemctl enable mariadb

Step 2 – Secure MariaDB Installation

First, you will need to secure MariaDB and set a root password. You can do it with the following command:

mysql_secure_installation

Answer all the questions as shown below:

Enter current password for root (enter for none): 
OK, successfully used password, moving on...
Set root password? [Y/n] Y
New password: 
Re-enter new password: 
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y

Once MariaDB is secured, you can proceed to the next step.

Step 3 – Install MyWebSQL

First, you will need to download the latest version of MyWebSQL from the Sourceforge website.

wget https://sourceforge.net/projects/mywebsql/files/v3.9/Version%203.9.zip

Once the download is completed, unzip the downloaded file with the following command:

unzip Version\ 3.9.zip

Next, move the extracted directory to the Apache root directory:

mv Samnan-MyWebSQL-36564f5 /var/www/html/mywebsql

Next, change the ownership of the mywebsql directory to apache:

chown -R apache:apache /var/www/html/mywebsql/

Once you are finished, you can proceed to the next step.

Step 4 – Access MyWebSQL Web Interface

Now, open your web browser and type the URL http://your-server-ip/mywebsql. You will be redirected to the MyWebSQL login page:
MyWebSQL login page
Provide your MariaDB root username and password and click on the Login button. You should see the MyWebSQL dashboard on the following page:
MyWebSQL dashboard page

Conclusion

In this post, you learned how to install MyWebSQL on Oracle Linux 8. You can now install and use MyWebSQL to perform all database-related operations via a web browser. Try it on dedicated hosting from Atlantic.Net!

Get a $250 Credit and Access to Our Free Tier!

Free Tier includes:
G3.2GB Cloud VPS a Free to Use for One Year
50 GB of Block Storage Free to Use for One Year
50 GB of Snapshots Free to Use for One Year