MySQL: Add a User to a Database If you haven’t yet created a MySQL database in cPanel, follow the instructions in our cPanel Beginner’s Guide to learn how to do so. If you’ve already built a database or two, but you need to change or add a specific user, simply
Creating a cPanel Backup via SSH To create a backup of your individual cPanel account using SSH, just follow these steps: First, log in to SSH as the Root user. Next, enter the following command string on the command line interface: /scripts/pkgacct username A backup of your account will be
You already know how important the information stored in your MySQL databases is. If that data gets lost, it can be difficult to recover from. This is where preventative measures, like creating a backup of your MySQL database, come in. Luckily, with cPanel, keeping copies of your data is a
Sometimes, an error in permissions or syntax within a script will result in an Internal Server Error 500, also known as an HTTP Error 500. But what does this mean, and how do you fix it? Well, in order to fix an HTTP Error 500, you must first understand what
A cron job is a Linux command used for scheduling tasks to be executed sometime in the future. This is normally used to schedule a job that is executed periodically – for example, to send out a notice every morning. Some scripts, such as Drupal and WHMCS may require you
By default, PhpMyAdmin in a cPanel server imposes an upload limit of 50MB. So, importing a SQL file larger than 50MB may time out. To increase the default upload limit, just follow these steps. First, log in with SSH and root. Next, search the path of php.ini (generally, it’s located
If your cPanel account is giving you the error “Sorry the domain is already set up,” it’s probably due to one of two different reasons. On it’s own, this error simply means that the domain in question still exists within the virtualhost in the apache httpd.conf configuration file. In the
What is mysql_upgrade? If your server runs MySQL databases, then the mysql_upgrade command is one you’ll want to familiarize yourself with. Available only in Unix, mysql_upgrade is a command that checks all tables in all databases for incompatibilities with your current version of the MySQL Server. After checking your databases,
With it’s ease of use and high reliability, MySQL is one of the most popular database solutions in the world. If you’re looking for instructions on how to download, install, and perform basic functions using MySQL, this guide will teach you everything you need. Downloading the Current Release of
In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave to lag behind the master. This means that if the master fails, it is possible that the slave might not have recorded the last few
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your MySql.sock file is missing or has been deleted. By following these steps, you’ll be able to diagnose and determine which actions must be taken to