How to install MyWebSQL on Debian 10?

Windows Articles

How to Update to MIUI 12 via Fastboot

Greetings friends. The new version of the Android-based operating system MIUI 12 released this year, is still being deployed with some devices missing. On...

How to use modprobe command?

The modprobe command is a Linux administration system created for management, visualization, inclusion and exclusion. From loadable modules to kernel. Also, the Module is...

Install Virtualmin on CentOS 8

Hello, friends. In this post, you will learn how to install Virtualmin on CentOS 8. In addition to that, we will leave it ready...

Different ways to open File Explorer in Windows 10

Hello! Certainly the archive scan is an essential element when it comes to controlling the contents. It is even so important, that there are...

How to setup WireGuard VPN with ubuntu 20.04

Here, we will learn today how to configure WireGuard VPN with Ubuntu 20.04. Wireguard® is an amazingly straightforward yet quick and present-day VPN that...
angeloma
angeloma
Senior Writer and partner

Managing a database server with MySQL is not an easy task. Therefore, specialized tools are required to improve the task. In Osradar we are aware of this and we like to talk about this type of tools. Today, we will talk about another one and we will teach you how to install MyWebSQL on Debian 10.

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 Debian 10.

Install MyWebSQL on Debian 10

1) Upgrade your system

The first step is, of course, to update the system. With this, we will be able to have the security patches correctly installed.

So open a terminal session and run the following:

:~$ sudo apt update
:~$ sudo apt upgrade

That way the system will be a little safer and we will be ready to go.

2) Install LAMP on Debian 10

MyWebSQL is a web application that needs a server to run. So you can deploy a LAMP server for it.

Read, How to install LAMP on Debian 10?

After everything is in place, we can continue.

3) Create a new user on MariaDB

When we use web tools to manage MySQL or MariaDB, it is best to create a new user. And to this new user, give permissions on the rest of the databases and tables.

So let’s go for it:

:~$ sudo mysql -u root -p
> USE mysql;
> CREATE USER 'angelo'@'localhost' IDENTIFIED BY 'Angelo12.,';
> GRANT ALL PRIVILEGES ON . TO 'angelo'@'localhost';
> FLUSH PRIVILEGES;
> exit;
1.- Creating a new user on MariaDB
1.- Creating a new user on MariaDB

Now we can install MyWebSQL without problems.

4) Installing MyWebSQL on Debian 10

Unfortunately, there is no DEB package for Debian. However, the installation is quite simple. Just download the application files into the Apache folder.

First, download it:

:~$ wget https://newcontinuum.dl.sourceforge.net/project/mywebsql/stable/mywebsql-3.7.zip
2.- Download and install MyWebSQL on Debian 10
2.- Download and install MyWebSQL on Debian 10

Then, we proceed to decompress it in the root folder of Apache.

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

In the end, we only need to grant the necessary permissions for the application to run correctly:

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

That’s enough. Now let’s try it.

Now, open your favorite web browser and go to the following address http://your-server/mywebsql/install.php to verify that everything is in order.

3.- Installing MyWebSQL
3.- Installing MyWebSQL

As everything is in order, you can log in on http://your-server/mywebsql/ and delete the installation file.

:~$ sudo rm /var/www/html/mywebsql/install.php
4.- MyWebSQL login screen
4.- MyWebSQL login screen

Now, type in your MariaDB credentials. And you can start to work.

5.- MyWebSQL on Debian 10
5.- MyWebSQL on Debian 10

So, enjoy it.

Conclusion

Managing a lot of data in MySQL or MariaDB is not so easy to do in a terminal. So these tools are always welcome to help us with the task. Today, you have learned to install MyWebSQL on Debian 10 and as you can see the process is quite simple.

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article

How to Update to MIUI 12 via Fastboot

Greetings friends. The new version of the Android-based operating system MIUI 12 released this year, is still being deployed with some devices missing. On...

How to use modprobe command?

The modprobe command is a Linux administration system created for management, visualization, inclusion and exclusion. From loadable modules to kernel. Also, the Module is...

Install Virtualmin on CentOS 8

Hello, friends. In this post, you will learn how to install Virtualmin on CentOS 8. In addition to that, we will leave it ready...

Different ways to open File Explorer in Windows 10

Hello! Certainly the archive scan is an essential element when it comes to controlling the contents. It is even so important, that there are...

How to setup WireGuard VPN with ubuntu 20.04

Here, we will learn today how to configure WireGuard VPN with Ubuntu 20.04. Wireguard® is an amazingly straightforward yet quick and present-day VPN that...
x