Install MyWebSQL on Ubuntu 18.04?

2
148

Setting up a data server with MySQL or MariaDB is quite a simple task and we have done it many times in this blog. However, when we are on the client side, managing, editing and viewing the data stored in MySQL or MariaDB can be a cumbersome task. Fortunately, there are tools that can help us with that task. So, why today I will show you how to install MyWebSQL on Ubuntu 18.04.

MyWebSQL is an open source tool to manage data stored in MySQL or MariaDB. However, it is not only limited to them but is compatible with PostgreSQL and SQLite. Therefore, we are in the presence of an essential tool on the client side.

So, let us install MyWebSQL on Ubuntu 18.04.

1. Install Apache web server and PHP

First, it is necessary to install a web server. Therefore, I will install the Apache Web server. It is simple, free and it is available in the official Ubuntu repositories, so everything will be faster.

:~$ sudo apt install apache2
1.- Install Apache
1.- Install Apache

Once the installation has finished, the service will start automatically. However, if you want Apache to run at system startup, run the following command:

:~$ sudo systemctl enable apache2

After that, you need to install PHP, some of their modules and other necessary packages.

:~$ sudo apt install php libapache2-mod-php php php-common php-mbstring php-gd php-intl php-curl php-xml php-mysql php-pgsql php-mysql php-bcmath unzip wget
2. Install PHP and some of their modules
2. Install PHP and some of their modules

Verify the installed PHP version with the following command.

:~$ php -v
3.- PHP version
3.- PHP version

Then, it is a good idea to test the Apache and PHP installation. To do it, create a new file called test.php on the /var/www/html/ folder.

:~$ sudo nano /var/www/html/test.php

Now, add the following:

<?php
phpinfo();
?>
4.- Creating a new file to test PHP
4.- Creating a new file to test PHP

Press CTRL + O to save the changes and CTRL + X to close the editor.

After that, restart the Apache web server service.

:~$ sudo systemctl restart apache2

Finally, open your web browser and go to http://SERVER_IP/test.php.

5.- PHP info
5.- PHP info

If the PHP information is shown in the browser as in the previous image. Then everything is fine.

2.- Install a Database manager

As I said before, MyWebSQL is compatible with several database handlers. In this section, you can install the one you want. However, for this example, I will use MySQL which is perfectly compatible with MyWebSQL so let’s go for it.

:~$ sudo apt install mysql-server
6.- Install MariaDB
6.- Install MariaDB

Now, it is time to set a new root password for MySQL. You can do it using the mysql_secure_installation script.

:~$ sudo mysql_secure_installation
7.- Using mysql_secure_installation
7.- Using mysql_secure_installation

Now, answer the question like the following way:

Change root password? Y
Remove anonymous users? Y
Disallow root login remotely? Y
Remove test database and access to it?  Y
Reload privilege tables now?  Y

So, that is all for MySQL.

Next, create a new user for MyWebSQL. You can use the user and password you want.

:~$ sudo mysql -u root -p
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO 'angelo'@'localhost' IDENTIFIED BY 'Angelo12.,';
FLUSH PRIVILEGES;
exit;

3. Install MyWebSQL on Ubuntu 18.04

now it’s time has come to install MyWebSQL, first, you need to download it. For now, the last stable version of the program is 3.7. So, run this command:

:~$ wget https://newcontinuum.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.7.zip
8.- Download and install Mywebsql on Ubuntu
8.- Download and install Mywebsql on Ubuntu

Next, decompress it on the Apache root folder.

:~$ sudo unzip mywebsql-3.7.zip -d /var/www/html
9.- Decompress the folder
9.- Decompress the folder

After that, set the correct permissions.

:~$ sudo chown -R www-data:www-data /var/www/html/mywebsql/
:~$ sudo chmod -R 775 /var/www/html/mywebsql/
10.- Set the correct permissions
10.- Set the correct permissions

Now, complete the installation from the web interface. Open the web browser and go to http://SERVER_IP/mywebsql/install.php

11.- Installation
11.- Installation

After that, access to the MariaDB instance using the right credentials.

Log in
Log in

Then, you will see the main screen of the application.

MyWebSQL
MyWebSQL

So, that is it.

Conclusion

MyWebSQL is a great help tool for data management using MySQL, MariaDB, PostgreSQL or SQLite. It’s a great alternative to PHPMyAdmin and honestly, I like it better.

You can also read our post about installing MyWebSQL on CentOS 7.

Please share this post with your friends.

2 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here