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

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

FastComet
$1.79 /mo
Starting price
Visit FastComet
Rating based on expert review
  • User Friendly
    4.7
  • Support
    5.0
  • Features
    4.8
  • Reliability
    4.5
  • Pricing
    5.0
Kamatera
$4.00 /mo
Starting price
Visit Kamatera
Rating based on expert review
  • User Friendly
    3.5
  • Support
    3.0
  • Features
    3.9
  • Reliability
    4.0
  • Pricing
    4.3
HostArmada
$2.49 /mo
Starting price
Visit HostArmada
Rating based on expert review
  • User Friendly
    4.5
  • Support
    4.5
  • Features
    4.5
  • Reliability
    4.5
  • Pricing
    4.0

How to Install OpenCart on an Ubuntu 18.04 Server or VPS with Apache, MariaDB and PHP 7

In this how-to, you'll learn how to install OpenCart, an open source shopping ca
3 min read
Angela Olaru
Angela Olaru
Senior Writer & Hosting Expert

How to Backup Your MySQL Database on an Ubuntu 18.04 VPS or Dedicated Server

This article shows you how to back up a MySQL database on a Linux Ubuntu 18.04 s
3 min read
Eliran Ouzan
Eliran Ouzan
Web Designer & Hosting Expert

How to Disable MySQL 5 "Strict Mode" on an Ubuntu 18.04 VPS or Dedicated Server

How to Disable MySQL Strict Mode on MySQL 5.6 Running on an Ubuntu 18.04 VPS.
2 min read
Idan Cohen
Idan Cohen
Marketing Expert

How to Install PhpMyAdmin on a Ubuntu 18.04 VPS or Dedicated Server

This article will describe the process of installing phpMyAdmin on an Ubuntu 18.
3 min read
Eliran Ouzan
Eliran Ouzan
Web Designer & Hosting Expert
HostAdvice.com provides professional web hosting reviews fully independent of any other entity. Our reviews are unbiased, honest, and apply the same evaluation standards to all those reviewed. While monetary compensation is received from a few of the companies listed on this site, compensation of services and products have no influence on the direction or conclusions of our reviews. Nor does the compensation influence our rankings for certain host companies. This compensation covers account purchasing costs, testing costs and royalties paid to reviewers.
Click to go to the top of the page
Go To Top