How to Create a Database and User for MySQL in cPanel

Related documents:
1. How to Add Databases and Users Using MySQL Wizard in cPanel
2. How to Allow Remote Access to a MySQL Database in cPanel
3. How to Change the Password of a MySQL User in the cPanel
4. How to Optimize a MySQL Database in cPanel

This article will give you a step by step guide on how to create a new database and a new user for MySQL.

Sign into your cPanel and follow these steps:

1) Scroll down to Databases and click MySQL Databases

1

2) To create a new database, enter the databases name and click Create Database

2

3) Click Go Back

3

4) To add a new user, enter the new user name. Then create and confirm the password. Finally, click Create User

4

5) Click Go Back

5

6) To add a user to a database, start by selecting the user from the User drop down bar. Then select the database you would like to put the user into from the Database drop down bar. Finally, click add

6

7) Select the privileges you want to allow the user to have in the database by checking the boxes next to the corresponding privileges. Then, click Make Changes

7

8 ) Click Go Back

8

This concludes how to create a new database and new user for MySQL

Looking for quality cPanel Hosting? Check out Arvixe Web Hosting!

Tags: , , , , , , , | Posted under cPanel/Linux Hosting, MySQL, Video | RSS 2.0

Author Spotlight

Arian Jahansouz

Arian Jahansouz

Hello, I am Arian! I have been writing for Arvixe since 2009 and now head the Arvixe Blog. Feel free to contact me at any time with questions or comments!

2 Comments on How to Create a Database and User for MySQL in cPanel

  1. Naira says:

    Thank you ! Great tutorial!

    Naira Jorge

  2. Omscowonder says:

    Thanks alot. this tutorial really helped me.
    A customer rep directed me here

Leave a Reply

Your email address will not be published. Required fields are marked *


8 × = 40

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>