How do I install MyWebSQL on RHEL 8 / CentOS 8?. MyWebSQL is an open source web-based WYSIWYG Database client written in PHP for performing Database operations. It offers features similar to those of phpMyAdmin. MyWebSQL has support for MySQL, PostgreSQL and SQLite databases.
Features of MyWebSQL
- Zero configuration installation
- Multiple Syntax highlighted SQL editors
- WYSIWYG Table creator/editor
- Quick in-place multi-record editing
- Multilingual Interface with themes support
- Import database script, export database, tables or results to multiple formats
- and many others.
The process of setting up MyWebSQL on RHEL 8 / CentOS 8 is easy since no installation is needed, just download, extract and you are ready to go. Below is a summary of steps to follow.
Step 1: Install PHP
MyWebSQL requires PHP runtime to work. Install PHP on RHEL 8 / CentOS using the guide in the link below.
How to Install PHP on RHEL 8 / CentOS 8
You must have php-fpm service running.
sudo systemctl enable --now php-fpm
Step 2: Install Apache Web Server
Installation of Apache web server was covered in our previous guide.
How to Install Apache with mod_ssl & mod_http2 on RHEL 8 / CentOS 8
The service should be started and set to start at boot.
sudo systemctl enable --now httpd
Step 3: Install MySQL / MariaDB Database
You need a working MariaDB or MySQL database server in order to use MyWebSQL. If you don’t have one, refer to our guides.
How to Install MySQL 8.0 on RHEL 8
How to Install MariaDB Database Server on RHEL 8
Step 4: Downloading MyWebSQL file
We will be downloading the most recent version of MyWebSQL (mywebsql-3.7.zip).
sudo yum -y install wget
wget https://downloads.sourceforge.net/project/mywebsql/stable/mywebsql-3.7.zip
Uncompress downloaded file.
unzip mywebsql-3.7.zip
Move mywebsql folder to //var/www/html/ directory.
sudo mv mywebsql /var/www/html/
Set SELinux context for the directory.
sudo semanage fcontext -a -t httpd_sys_content_t "/var/www/html/mywebsql(/.*)?"
sudo restorecon -Rv /var/www/html/mywebsql
Restart httpd service.
sudo systemctl restart httpd
Visit the URL http://[IP_or_hostname]/mywebsql/.
Login with database username and password.
Start administering your Database Server from a Web interface.
Related content:
