How To Install MyWebSQL On an Ubuntu 18.04 VPS or Dedicated Server

Introduction

MyWebSQL is a fast, efficient and interactive web-based database client that offers a WYSIWYG user interface to manage databases online. It's a simple software written in PHP and features a familiar feel and look of a desktop application. The solution is open-source and free to download and deploy on your Ubuntu 18.04 server to manage your MySQL, SQLite, MariaDB, and PostgreSQL databases.

This tutorial will take you through the process of installing MyWebSQL on your Ubuntu 18.l04 system. Once, the application is installed you no longer need to manage your database from a command line terminal or desktop client, you will leverage the power of your favorite browser to manage them all.

Prerequisites

Before we begin, there are a few things that must be put in place to facilitate the installation. They include:

If everything is in place, then you are ready for this simple and straightforward installation.

Let’s get started!

Step 1 Installing And Configuring MyWebSQL

The first thing when installing the MyWebSQL is to download the application’s files. Execute the command below to download the required files:

$ cd /tmp && wget https://phoenixnap.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.7.zip

Next, run the following command to extract the files you have downloaded to the root directory of your web server (Apache2):

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

The command above will create a folder called mywebsql. Now, run the following commands to modify the permission of the root folder:

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

Next, execute the command below to restart the Apache service:

$ sudo systemctl restart apache2

By now, your MyWebSQL application should be fully installed and configured.

Step 2 Accessing MyWebSQL

Once, the MyWebSQL is installed, open your favorite browser and search http://localhost/mywebsql. Replace the value “localhost” with the hostname or IP address of your server. If everything works out well, this you will take you to a page similar to the one below:

How To Install MyWebSQL on Ubuntu 18.04 LTS

Log in with the credential of your MariaDB root account.

How To Install MyWebSQL on Ubuntu 18.04 LTS

If you get an error when trying to log in to MyWebSQL, then you must adjust the logon issue to stop the error. To solve the MySQL root user complications, first log in to your MariaDB server:

$ sudo mysql -u root

Enter your credentials (username and password) and press ENTER. Once you are in the MariaDB database shell prompt, execute the command below:

use mysql;
updateusersetplugin=''whereUser='root';
flushprivileges;
Exit

This will disable the root user’s plugin authentication and clear the error that prevented you from accessing MyWebSQL.

Next, execute the command below, to restart MariaDB and create a new password:

$ sudo systemctl restart mariadb.service

You should be able to log in to your MyWebSQL application.

Conclusion

Congratulations! You have successfully installed MyWebSQL via the command prompt on Ubuntu 18.04. Enjoy the convenience and efficiency of managing your databases on the web.

Check out these top 3 Linux hosting services

Was this article helpful?