Step 1: Login to your control panel. Click the MySQL account maintenance.
Step 2: Under "Create New Database", enter the name of the new database and Click Create database.
Step 3: This will create a database with the name mainuser_databasename. (mainuser refers to CPanel login username)
Creating a MySQL User :
Step 1: Under "Current Users", enter the username and password and click Create User. This will create a user with username as mainuser_user.(mainuser refers to CPanel login username)
Creating a user does not automatically allow the user to use a database - you need to grant that user permission to the specific database first.
Granting Permission to MySQL User :
Step 1: Under "Add Users to your Database", select the user(the user will appear as mainuser_user) you wish to grant permissions for(from the drop box next to User:).
Step 2: Select the database(the database will appear as mainuser_database) you wish to give that user access to(from the drop box next to Database).
Step 3: Select any privileges(abilities to modify the database) you wish the user to have by checking the box next to the privilege's name.
Step 4: Click on Add User to Database to give the user permission to access the database. (mainuser refers to CPanel login username).
Note: You are also provided with a Video Tutorial link on the top left corner that assists you in creating and modifying MySQL databases in cPanel.
- 0 Users Found This Useful
What is FTP?
FTP (File Transfer Protocol) is a method used to transfer files between your computer and the web server. FTP is usually performed via a FTP Client, which connects to the FTP server and allows you...
What is SSH?
SSH (Secure Shell) is a secure method for logging into a server remotely and giving the server commands or transferring files. SSH makes it extremely easy to manage a server without having to be at...
Email Policy & Anti Policy
Anti-Spam Policy Email is not for the delivery of Unsolicited Bulk Email, or Unsolicited Commercial Email, otherwise known as SPAM and we refer to the definition of SPAM provided by the...
What is Bandwidth Limit?
What happens when the bandwidth limit is not fully utilized? There will not be any problem, if your bandwidth limit is not totally used. Note that at the starting of every month, the...