Skip to Content

Welcome!

This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.

This question has been flagged
As a moderator, you can either validate or reject this answer.
Accept Reject
1 Reply
61 Views

How to create and manage databases and database users in cPanel.

Avatar
Discard
Author Best Answer

Create a Database

1. Login to cPanel with the cPanel username and password.

2. Click on the "MySQL Databases" icon.


3. In the "Create New Database" section, enter a database name and click Create Database. Usually just put database name end with "_main"



Create a User

1. From the "MySQL Databases" page, scroll down to "MySQL Users".

2. Enter a MySQL username and password, click "Create User". The username also end with "_main"



Link User to Database

1. From the "MySQL Databases" page, scroll Down to the "Add User To Database" section.

2. Select your new user and new database and click Add.


3. Put a check next to "ALL PRIVILEGES", or, optionally, select individual privileges.


4. Click "Make Changes".


Avatar
Discard

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

Related Posts Replies Views Activity
1
Nov 23
76
1
Mar 24
86
1
Feb 24
75
1
Jan 24
128
1
Jan 24
66