MySQL

Restore Database Using PHPMyAdmin

This article is about restoring your databases from a backup. This guide is intended for clients who wish to restore their database using PHPMyAdmin. If you want to do this, you’ll need to have access to cPanel such as with Hostwinds Shared Hosting and Business Hosting, Cloud, VPS or a Dedicated Server and be using cPanel.…

Definition of Databases Icons

The Database section in cPanel allows you to administer every aspect of your MySQL database. Using this interface you can do things such as create new databases, add users to existing databases, and manage database tables to name a few. It is suggested to create all new databases through cPanel before working with them directly.…

How to Repair a Database

If a database crashes, or otherwise becomes unresponsive, you may need to repair it to restore functionality back to your site. This article will explain how to repair a MySQL database from within cPanel. Please note that you’ll need to be logged into cPanel before proceeding any further. If you’re not certain how to do…

How to Backup a MySQL Database in cPanel

How do I Backup a MySQL Database in cPanel? This article will cover how to perform a MySQL database backup in cPanel. Please note that you’ll need to be logged into cPanel before proceeding. If you’re not sure how to login to cPanel, please check out our guide: How to access cPanel. To generate a…

How to Increase the Timeout in PHPMyAdmin

If you have VPS and happen to be running phpMyAdmin then you may have ran into the following: No activity within 1440 seconds; please log in again This can be a bit frustrating if you happen to be working on something at the time. The following guide will walk your through the steps of increasing…

Adding a Secondary MySQL Server

How do I setup a separate server for MySQL in WHM? You can setup a server to handle MySQL, which can help if your site(s) get a lot of traffic or are running big databases. (See below for important notes)   Install MySQL on the remote MySQL server if it’s not already installed Log in…

Additional MySQL Access Hosts

How do I add additional MySQL access hosts? You can assign additional MySQL access hosts in WHM by doing the following: Login to WHM Go to Home > SQL Services This can be located quickly by searching for “sql” in the search bar Select “Additional MySQL Access Hosts”     Put the IPs you want…

PHPMyAdmin Overview

What is PHPMyAdmin?   The administration of a MySQL database throughout the internet is managed by a tool written in PHP called PHPMyAdmin.  The database itself is first setup in cPanel but PHPMyAdmin manages its functions.  For example, PHPMyAdmin can create and alter databases. You can use it to add, edit, delete fields, drop entire databases,…

MySQL Additional Access Hosts

How do I Allow Remote Access to my Database? You can allow remote access to your MySQL database in cPanel by doing the following: Login to cPanel Under the Databases section select Remote MySQL®     Put the IPs you want in the text box Click the Add Host button     Note: This interface also allows for…

Adding a MySQL user to a database

How do I Add a User to a MySQL Database? You can easily add a user to specific MySQL databases in cPanel by doing the following instructions below.    Go to Home > Databases > MySQL Databases     Scroll to the Add User To Database section Pick the desired user and database from the…

  • Page 1 of 2
  • 1
  • 2