How to Install PhpMyAdmin

Introduction While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt. phpMyAdmin was created so that users can interact with MySQL through a web interface. In this guide, we’ll discuss how to install and secure phpMyAdmin so that you […]

Continue reading


MySQL Workbench Tutorial

MySQL is an open source relational database. MySQL is cross platform which means it runs on a number of different platforms such as Windows, Linux, and Mac OS etc. Why use MySQL? There are a number of relational database management systems on the market. Examples of relational databases include Microsoft SQL Server, Microsoft Access, Oracle, DB2 etc. One […]

Continue reading


MySQL on Linux Tutorial

The MySQL Database Installation and configuration: Red Hat / Fedora Core RPM Packages: RHEL 6/CentOS/AWS MySQL 5.5 example: mysql-version.rpm (Required. Includes client) mysql-server-version.rpm (Required) mysql-config-version.rpm (Required config file: /etc/my.cnf) mysql-devel-version.rpm (Optional: C include files and libraries for developers) php-mysql-version.rpm (Optional: For accessing MySQL database from php) Install: rpm -ivh mysql-version.rpm mysql-server-version.rpm mysql-config-version.rpm Check if installed: rpm -q mysql […]

Continue reading


How To Secure Apache

Introduction Let’s Encrypt is a Certificate Authority (CA) that provides an easy way to obtain and install free TLS/SSL certificates, thereby enabling encrypted HTTPS on web servers. It simplifies the process by providing a software client, Certbot, that attempts to automate most (if not all) of the required steps. Currently, the entire process of obtaining and […]

Continue reading


phpMyAdmin Installation Tutorial

All hosting accounts on the SiteGround servers come with pre-installed phpMyAdmin software. The application can be opened from cPanel -> phpMyAdmin tool. However, you may need to install phpMyAdmin manually. The easiest way is to install the application from the Softaculous tool in cPanel. Alternatively, you can perform the installation manually. Manual PhpMyAdmin Installation To install phpMyAdmin manually, […]

Continue reading