Recently, I was telling you about Adminer, an extraordinary front end for MySQL and MariaDB. I was saying that this kind of application can be a bit misleading because they are so light that they do not seem to be powerful. However, the opposite is true. Well, today I will tell you how to install SQLBuddy on CentOS 8 and instead of its special features.
SQLBuddy is an application that provides a web interface for data in MySQL and SQLite. It is quite light and easy to install on a server. Thanks to its lightness we can be sure that it will not consume resources unnecessarily.
On the other hand, it is a very complete application because not only we will be able to visualize data but also we will be able to execute all type of SQL sentences. This makes working with MySQL or SQLite much easier. In addition, SQLBuddy is created and thought to be a secure application so we can be sure that there will be no problems when using it.
In addition, it has quite easy to meet requirements such as PHP 4.3 or higher and MySQL 4+ practically non-existent in most Linux distributions. It also supports a lot of web browsers including the proprietary Safari and Opera. So access will not be a problem.
Install SQLBuddy on CentOS 8
SQLBuddy is a web application made with PHP. So, we need a functional web server in our computer. So, the first step is to install LAMP on CentOS 8.
How to install LAMP on CentOS 8?
After installing LAMP and configuring our MySQL or MariaDB instance. Just make sure the wget and unzip packages are installed.
:~# dnf install wget unzip
Next, navigate to the Apache folder and download the program.
:~# cd /var/www/html/ :~# wget -c https://github.com/calvinlough/sqlbuddy/raw/gh-pages/sqlbuddy.zip
Then, decompress the file.
:~# unzip sqlbuddy.zip
It is advisable to delete the downloaded file.
:~# rm sqlbuddy.zip
Before being able to access it is necessary to change the permissions of the folder. Also, the owner of the same one to avoid problems of execution.
:~# chmod 755 -R sqlbuddy/ :~# chown -R apache:apache sqlbuddy/
Finally, open your web browser and log in.
Now, enjoy it.
SQLBuddy is another great alternative to PHPMyAdmin with very good and useful features to visualize our MySQL data. Best of all, it’s easy to install.