MySQL Tutorial: Creating MySQL Database and User

By | March 13, 2013

How to create My SQL Database and User?

Firstly check out how to create and modify database on My SQL video Tutorial:

You need not require to worry about creating My SQL database with cPanel as it is already included in Hosting plan of Inway Hosting. Firstly log in to cPanel for creating My SQL database on your hosting account. You can do this either by clicking on cPanel button located in customer area –>> my account segment or by pasting direct link in the web browser.

http://yourdomainname.com/cpanel

http://cpanel.servername.com

Then “yourdomainname.com” has to be replaced with actual domain name or servername.com has to be replaced with host name of Inway hosting the server on which your account has been hosted. We provide unlimited hosting india

After logging into cPanel, you can access My SQL management screen and click on the corresponding my SQL database option shown below:

Create database

For creating a new database, enter your desired name in the New Database section and click on Create database button mentioned below:

Create database (2)

After that you will receive a confirmation massage, which shows that your database has been created successfully.

Create database (3)

Click on “Go back” button to revisit the Database management screen. My SQL database created will use your username as prefix – username_databasename and this name will be applicable for using applications also.

A detailed Tutorial on How to create a My SQL Username?

You can create a new user which can connect to newly developed database. For creating a new user, fill your username and password in the space provided as mentioned below in the given image:

Create database (4)

Click on “save” button to save your My SQL username.

Please note that to all the databases and usernames created by you, cPanel username will be added as a prefix to them.

A Detailed Tutorial on How to add a User to My SQL Database?

After creating Database and Username, you can add some rights to the database for the User. Choose them from the respective Drop down menu under section of Add User to Database and click on Submit button.

 

Create database (5)

In the next step, you will be redirected to the new page and will be prompted to select desired rights or privileges. Choose All Privileges and click on make changes icon.

Create database (6)

Use My SQL Database Wizard

My SQL database wizard helps you in completing all the steps successfully. Once you click on it, you will be guided through all the detailed steps for creating a new My SQL database and adding a user to it successfully. We provide Cheap hosting India

Create database (7)

Leave a Reply