Category: Tutorials
The Liquid Web knowledgebase provides information on thousands of topics surrounding every aspect of hosting, Linux, Windows, and countless other article types that help boost your Liquid Web experience!
Remote MySQL connections are disabled by default in cPanel servers because they are considered a potential security threat. Using the tools in the Web Host Manager (WHM) and the domain-level cPanel interface (usually http://domainname.com/cpanel) remote hosts can be added which the server allows connecting to the MySQL service.
How to Replace PHP GeoIP with MaxMindDB
Depending on the site or application, looking up geographic information related to an IP address can be a pretty common action. When doing IP geolocation in PHP usually the PHP GeoIP extension would be used to facilitate the retrieval of this information. Unfortunately, this particular plugin is no longer actively supported and has not been updated in a number of years.
Working with Composer & Examples
In the previous articles we worked through what composer is, who uses it, and how to install it. Here we will cover some basic use case examples of how to acquire packages using the composer tool we previously setup.
Installing Composer on cPanel servers
With a tool like Composer it is generally best to have the ability to run it as any user on the server and from any directory. This is generally referred to as being 'globally installed' as any user can access the tool from any location. In this guide we will detail how to install Composer globally on a cPanel based server.
Composer 101
Composer is a dependency manager for PHP, written in PHP. Specifically, it’s used to simplify the process of using PHP libraries in your projects. The use can range from getting a framework, including a library class, or open source projects; generally these packages are downloaded by Composer and then implemented by a developer in a website’s code.
Examples being: Silex MicroFramework, the infamous PHPMailer class, Laravel Framework, and many more - all of which can be found on Composer’s main repository Packagist.
MySQL’s, and MariaDB’s, strict mode controls how invalid or missing values in data changing queries are handled; this includes INSERT, UPDATE, and CREATE TABLE statements. With MySQL strict mode enabled, which is the default state, invalid or missing data may cause warnings or errors when attempting to process the query.
How To Configure Your Server to Log Real Visitor IPs
Because CloudFlare acts as a proxy, all visits to your website and web applications will, by default, be logged as originating from a CloudFlare IP address — not the visitor’s actual IP address. However, the Apache module mod_cloudflare can be used to ensure that visitors’ actual IP addresses are logged and displayed. We recommend that you activate mod_cloudflare as outlined in this article to accurately log website visitor IP addresses and prevent unwanted behavior. Without this step, your server’s firewall could block CloudFlare’s IP addresses, making your site inaccessible. If you need to check whether the module is already enabled or need assistance installing it, please open a ticket and Heroic Support® will be happy to help.
Copying a table is quick and easy to do within PhpMyAdmin. Whether you are trying to make a backup copy before changes are made, archiving data, moving data to a new site or application, or even just working on restructuring your database, PhpMyAdmin can help you get the job done in just a few clicks.
How to Access cPanel File Manager
II. Understanding Menu Items in File Manager
III. Understanding File Structure in File Manager
IV. How To Create New Files and Folders in File Manager
V. How To Copy and Move Files in File Manager
VI. How To Rename Files in File Manager
VII. How To Upload and Download Files with File Manager
VIII. How To Edit Files with File Manager
IX. How To Change File Permissions with File Manager
X. How To Zip and Unzip Files in File Manager
Understanding File Structure in File Manager
II. Understanding Menu Items in File Manager
III. Understanding File Structure in File Manager
IV. How To Create New Files and Folders in File Manager
V. How To Copy and Move Files in File Manager
VI. How To Rename Files in File Manager
VII. How To Upload and Download Files with File Manager
VIII. How To Edit Files with File Manager
IX. How To Change File Permissions with File Manager
X. How To Zip and Unzip Files in File Manager
This tutorial assumes you’ve already logged in to cPanel’s File Manager.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.