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.
Before we begin, there are a few things that must be put in place to facilitate the installation. They include:
- Ubuntu 18.04 server and a user with sudo privileges.
- The installation requires Apache2, PHP, and MariaDB. For this reason, the LAMP (Apache, MariaDB, and PHP) stack must be installed on your Ubuntu 18.04 server. If you have not installed this stack follow our guide on How to install LAMP (Apache, MariaDB, and PHP) stack on Ubuntu 18.04
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:
Log in with the credential of your MariaDB root account.
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.
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.