Connecting to MySQL Using Python

Reading Time: 5 minutes

In this article, we will be discussing how to connect to MySQL using Python. Python is one of the most productive and widely used programming languages in use today. Its simple and elegant syntax makes it ideal for new programmers, while experienced programmers enjoy the extensive list of available modules and functionalities. 

MySQL is a robust open-source SQL-based, relational database management system that is used in many software programs and web servers. This article aims to show how to connect to use Python to connect to MySQL and perform some basic tasks. 

Continue reading “Connecting to MySQL Using Python”

How to Enable Piped Logging in Apache

Reading Time: 3 minutes

Apache by default logs data directly to log files. While this isn’t a bad thing, it is not your only option. Both Apache 1.x and Apache 2.x bring with them the option of enabling something called “Piped Logging”, though cPanel will only allow you to enable it for version 2.x.

Continue reading “How to Enable Piped Logging in Apache”

How to Create and Use MySQL Views

Reading Time: 6 minutes

What is a MySQL View?

A MySQL view is simply an ordinary database object that can save SQL query writers a lot of time when used correctly. A view is a stored query that a user can reference just like a table. Many times users will find themselves using the same base query over and over to solve multiple problems. Views are a way of quickly saving that query and referencing it later.  

Continue reading “How to Create and Use MySQL Views”

Running SQL Queries on a Database with PhpMyAdmin

Reading Time: 2 minutes

In this tutorial, we will explore how to run SQL queries on a database within PhpMyAdmin. SQL stands for Structured Query Language. SQL statements or queries are used to perform database tasks such as searching, updating, or retrieving data from a database.

Continue reading “Running SQL Queries on a Database with PhpMyAdmin”

How to Enable Remote MySQL Connections in cPanel

Reading Time: 2 minutesRemote 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. Before using either of the following techniques, you will need to open up port 3306 in your server’s firewall. Continue reading “How to Enable Remote MySQL Connections in cPanel”

How to Display (List) All Jobs in Cron / Crontab

Reading Time: 2 minutesServers can automatically perform tasks that you would otherwise have to perform yourself, such as running scripts. On Linux cloud dedicated servers or VPS servers, the cron utility is the preferred way to automate the running of scripts. In this article, we’ll cover how to view the jobs scheduled in the crontab list. For an introduction to Cron check-out our KB: How To: Automate Server Scripts With Cron. Knowing how to set up crontab is an important skill, but even if you’re not editing these knowing how to view them is important as well. Continue reading “How to Display (List) All Jobs in Cron / Crontab”

How To: Automate Server Scripts With Cron

Reading Time: 2 minutesServers can automatically perform tasks that you would otherwise have to perform yourself, such as running scripts. On Linux servers, the cron utility is the preferred way to automate the running of scripts. Continue reading “How To: Automate Server Scripts With Cron”

How To: Create a cPanel Account in WHM

Reading Time: 5 minutesRunning your first webserver can be daunting. Even if you are familiar with running a cPanel account, there is much to learn regarding Web Host Manager (WHM). The first step to successfully running WHM is creating a cPanel account. Continue reading “How To: Create a cPanel Account in WHM”

Digging Into Exim Mail Logs With Exigrep

Reading Time: 3 minutesPerhaps a particular domain on your cPanel server has stopped receiving e-mail. Or, an address on your domain is able to receive e-mail, except from your supplier. Maybe you can receive e-mail just fine, but are receiving error message bounce-backs from Yahoo. How are you going to get the fine-grained information you need to figure out just what is going on? The answers you seek can be found in exim’s logs. Continue reading “Digging Into Exim Mail Logs With Exigrep”