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
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
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
Nearly all web applications have a database back-end that require a MySQL database. During the application’s installation, you will be asked for these database details: MySQL Host – This is always “localhost” Username – The user assigned to the database with adequate permissions to manipulate it. Password – The password for the user assigned to
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.
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
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