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”

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 “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 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 setup 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: 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”

Updating an A record in cPanel

Reading Time: 2 minutesDomain Name System, or DNS, is a complex system to understand, but cPanel has simplified the administration of DNS by adding it to the WHM interface. One of the most common tasks involved with administrating DNS is updating an A record. A records are one of the most common DNS entries, and cPanel makes updating them easy.
This article assumes that you are running BIND on a Linux server, that you already have an understanding of what DNS is, the different types of DNS entries, and how DNS works. Please note: The incorrect editing of your zone file can take your site offline. All editing must be done on the authoritative nameservers for the given domain.

Continue reading “Updating an A record in cPanel”

Apache Error: “semget: No space left on device”

Reading Time: < 1 minuteIf Apache fails, and will not successfully start again, check the error log. If you see an error similar to the following, it could indicate that your server has run out of semaphores.

Continue reading “Apache Error: “semget: No space left on device””

WordPress Tutorial 4: Recommended WordPress Plugins

Reading Time: 3 minutesThis is part 4 in an ongoing series on WordPress. Please see Part 1: WordPress Tutorial 1: Installation Setup and Part 2: WordPress Tutorial 2: Terminology and Part 3: WordPress Tutorial 3: How to Install a New Plugin, Theme, or Widget.

__________

Now that you have WordPress installed, understand the interface, and know how to install new parts, let’s take a look at our recommended plugins.
Continue reading “WordPress Tutorial 4: Recommended WordPress Plugins”