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 & 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. Log into cPanel & locate the MySQL Databases icon Scroll down and locate the MySQL Users heading Enter a username in the field provided Enter a password twice into the provided fields (or

Continue reading…

Remote mySQL connections

In order to have remote mySQL connections to your hosting account, you must open a service ticket to have this allowed for your connecting IP address. We do not allow remote connections by default for security reasons.

Creating & deleting a mySQL database in cPanel

To create a new mySQL database in your cPanel hosting account, follow the steps below. Login to cPanel. Locate and click on the “MySQL Databases” icon in the “Databases” category. Under the “Create a New Database” heading, enter a name for your database. Click the “Create Database” button. 1. Locate the “MySQL Databases” icon as

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…