How to install MyWebSQL on CentOS 7?

0
541
database
Database

yu<?2.In this article, I will show you how to install MyWebSQL on CentOS 7. The tutorial is simple to do, but first I’ll tell you a little about this tool.

MySQL is an open-source relational database management system (RDBMS). It is very popular among developers for being free, easy to use and very secure. In many cases, it is the entry point to other more robust applications such as Oracle Database or IBM DB2.

Mysql
Mysql

At the same time, many people who start with MySQL don’t feel comfortable with the way they perform operations because everything is through CLI. With the aim of minimizing the difficulty to visualize data, create a database and perform more actions with MySQL using less time is that tools such as MyWebSQL emerge.

MyWebSQL is an open source, web-based, WYSIWYG MySQL client written in PHP. It utilizes modern day technologies and browsers to provide a fast, intuitive querying and editing interface to the MySQL databases.

It was created with the following points in mind.

  • Easy deployment and usage.
  • Fast querying and editing on MySQL databases.
  • Developer friendly to save time spent on queries and working with results.
  • Usable with all major browsers without any loss of functionality.

As you can see, it is a software designed to save time with MySQL. Let’s install MyWebSQL on CentOS 7.

0. Prerequisites

The installation is really simple, however, you must take into account the following:

  • MyWebSQL is also compatible with MariaDB which is a 100% MySQL compatible fork. It is the one I will use.
  • You have to install LAMP first. It is not difficult.
  • The commands must be executed as root user.
  • The packages wget and unzip, must be installed.

Let’s get to work.

1. Install Apache web server and PHP

The first element that you need is Apache web server. To do this, run:

:~$ su
:~# yum install httpd
1.- Installing Apache Web server
1.- Installing Apache Web server

Then, enable it and start it.

:~# systemctl enable httpd
:~# systemctl start httpd
2.- Starting the httpd service
2.- Starting the httpd service

Then, set the Firewall rule:

:~# firewall-cmd --zone=public --add-service=http --permanent
:~# firewall-cmd --reload
3.- Setting a Firewall rule to apache web server
3.- Setting a Firewall rule to apache web server

To check that the whole process has been successful, go to your web browser and go to http://IP_SERVER and if you see the following, then everything is fine.

4.- Apache default page on CentOS 7
4.- Apache default page on CentOS 7

Now is PHP’s turn.

:~# yum install php php-mysql php-cli php-xml php-gd
5.- Installing PHP
5.- Installing PHP

Create a new file called t.php on /var/www/html/

:~# nano /var/www/html/t.php

And put the following:

<?php
phpinfo();
?>
6.- phpinfo method
6.- phpinfo method

Save and close the file.

Next, you have to restart apache service:

:~# systemctl restart httpd

Now, go to the web browser and try to go to http://IP_SERVER/t.php. If you see this, PHP is installed.

7.- phpinfo() running
7.- phpinfo() running

Note: If you want to install a more recent PHP version, I explained it here.

2. Install MariaDB

Don’t be confused, MariaDB is a fork absolutely compatible with MySQL. In addition, it comes by default in the official CentOS 7 repositories. It currently has a great support and a very active community, so it is the best option.

To install MyWebSQL this step is vital.

:~# yum install mariadb-server
8.- Installing MariaDB server
8.- Installing MariaDB server

Then, start and enable the service:

:~# systemctl enable mariadb
:~# systemctl start mariadb
9.- Enabling the MariaDB service
9.- Enabling the MariaDB service

Now, configure MariaDB using the mysql_secure_installation script.

:~# mysql_secure_installation

First, log in without a password since it has not been defined and then create one. To the rest of the questions answer, as you want, I did so: Y, N, Y, Y.

10.- Configuring MariaDB server thanks to mysql_secure_installation script
10.- Configuring MariaDB server thanks to mysql_secure_installation script

3. Install MyWebSQL

The time has come to install MyWebSQL. First, you have to download it.

:~# cd /opt/
:~# wget https://downloads.sourceforge.net/project/mywebsql/stable/mywebsql-3.7.zip
11.- Download and install MyWebSQL
11.- Download and install MyWebSQL

The next step is to unzip it in the apache root directory, i.e. /var/www/html.

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

Restart Apache.

:~# systemctl restart httpd

And that’s it.

4. Accessing to MyWebSQL

After restarting Apache web server, you should be able to start the application. Open your web browser and go to http://IP_SERVER/mywebsql.

 

12.- MyWebSQL log in page
12.- MyWebSQL log in page

In the place, the credentials of your server. Username and password. And then access.

13.- MyWebSQL main page
13.- MyWebSQL main page

As this is a newly created instance, there is not much information to show. However, I will show MySQL users.

14.- Showing some information
14.- Showing some information

Conclusion

To install MyWebSQL requires certain prerequisites, however, its installation is really simple. This application is very useful for those who use MySQL on a daily basis and need to see data graphically and easily.

We want to know your opinion, did you know about this application? Have you used them? How was your experience with it?

Please share this article through your social networks.

LEAVE A REPLY

Please enter your comment!
Please enter your name here