MySQL Overview
Follow this guide to create a MySQL user, database, and configure permissions on your cPanel account
Overview
To create a MySQL User, proceed to the Create MySQL User section.
To create a MySQL Database, proceed to the Create MySQL Database section.
To configure MySQL User Permissions to a Database, proceed to the Configure MySQL User Permissions to a Database section.
To allow a remote IP to access the MySQL Database, proceed to the Remote IP Access section.
Create MySQL User:
- Login to the Client Area.
- Click on the Services.

- Select your active web hosting service.

- On the left sidebar, click Log in to cPanel.

- Once you are logged into cPanel, scroll down to Databases, then click MySQL Databases.

- From here, scroll down to the MySQL Users section where you can add new users and view current users.

- To create a new MySQL user, simply enter the username and password you would like to use for the user.

- Once you create the MySQL user, you will see the following.

Create MySQL Database:
- Login to the Client Area.
- Click on the Services.

- Select your active web hosting service.

- On the left sidebar, click Log in to cPanel.

- Once you are logged into cPanel, scroll down to Databases, then click MySQL Databases.

- From here, you can create a new MySQL Database. Simply name your new database, then click the Create Database button.

- Once you have created your database successfully, you will see a screen that looks like the following.

- You can now access your MySQL Database by navigating to the cPanel homepage by clicking the following button.

- Once you are logged into cPanel, scroll down to Databases, then click phpMyAdmin.

- You will then be navigate to a phpMyAdmin page where you can manage your database.

- To import an SQL file, simply select Import as shown below. Once you have uploaded your file, click the Go button.

Configure MySQL User Permissions to a Database:
- Login to the Client Area.
- Click on the Services.

- Select your active web hosting service.

- On the left sidebar, click Log in to cPanel.

- Once you are logged into cPanel, scroll down to Databases, then click MySQL Databases.

- From here, make sure you have a MySQL user already created, then scroll down to Add User To Database.

- Select the user and the database you would like to give them permission to access, then click the Add button. You will be brought to a page to manage the user’s permissions within the selected database. Select the desired permissions, then click Make Changes.

- If done correctly, you will see a success alert on the top right.

Remote IP Access:
- Login to the Client Area.
- Click on the Services.

- Select your active web hosting service.

- On the left sidebar, click Log in to cPanel.

- Once you are logged into cPanel, scroll down to Databases, then click Remote MySQL

- From here, you can Add Access Host and Manage Access Hosts. To allow all connections, insert a % into the Host field and click Add Host.

Thank you for being a dedicated customer. We very much value all of your business! ❤️
Did this answer your question?
😞
😐
🤩