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.
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
wgetandunzip, 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
Then, enable it and start it.
:~# systemctl enable httpd :~# systemctl start httpd
Then, set the Firewall rule:
:~# firewall-cmd --zone=public --add-service=http --permanent :~# firewall-cmd --reload
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.
Now is PHP’s turn.
:~# yum install php php-mysql php-cli php-xml php-gd
Create a new file called t.php on /var/www/html/
:~# nano /var/www/html/t.php
And put the following:
<?php phpinfo(); ?>
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.
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
Then, start and enable the service:
:~# systemctl enable mariadb :~# systemctl start mariadb
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.
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
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.
In the place, the credentials of your server. Username and password. And then access.
As this is a newly created instance, there is not much information to show. However, I will show MySQL users.
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.
