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 […]
Month: October 2024
Web Hosting at its Best
What is Web Hosting? and Comparing Fastest Web Hosting to Buy. Web hosting is a service that allows organizations and individuals to post a website or web page onto the Internet. A web host, or web hosting service provider, is a business that provides the technologies and services needed for the website or webpage to […]
Apache vs Nginx
Web server is essential for all server to serve the content over the internet. There are a lot of web servers available in the market. The two Major web servers are Apache and Nginx. A lot of people are confusing themselves about choosing the one among both of them. In this article, I am going […]
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 […]
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 […]
How To Configure the Apache Web Server
What is Apache? Apache is the most popular web server on the internet. It is used to serve more than half of all active websites. Although there are many viable web servers that will serve your content, it is helpful to understand how Apache works because of its ubiquity. In this article, we will examine […]
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 […]
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, […]