Category: Databases

Managing databases via SSH command line

Managing databases via the SSH command line is sometimes necessary & can be faster than using the phpMyAdmin web interface. If you do not currently have SSH access on your hosting account, you will need to request it via our support department as we do not enable SSH by default for security reasons. When using

Continue reading…

Import / Export a mySQL database using cPanel & phpMyAdmin

This tutorial assumes that you have already created a database. If you have not, you will need to do so first. To import a database into an existing database (.sql file) in cPanel using phpmyadmin follow the steps below. Log into your cPanel account Locate the “phpMyAdmin” icon found under the “Databases” section After phpMyAdmin

Continue reading…

Creating and Deleting a MySQL User in cPanel

To create a mysql database user in cPanel, follow the steps below. Once created, you’ll want to assign it to a database. Quick Steps: Step 1. Log into cPanel & locate the MySQL Databases icon Step 2. Scroll down and locate the MySQL Users heading Step 3. Enter a username in the field provided Step 4. Enter a password

Continue reading…

Creating & deleting a MySQL database in cPanel

This guide will show you how to create a new MySQL database in your cPanel hosting account, Quick Steps: Step 1. Login to cPanel. Step 2. Locate and click on the “MySQL Databases” icon in the “Databases” category. Step 3. Under the “Create a New Database” heading, enter a name for your database. Step 4.

Continue reading…

Adding a user to a mySQL database

To add a user to a mySQL database, follow the steps below from inside of your cPanel hosting account: Login to cPanel. Locate and click on the “MySQL Databases” icon under the “Databases” category. Locate the “Add User To Database” heading. Select the user you want to add the database, and then select the database

Continue reading…