{"id":428,"date":"2016-10-06T11:38:25","date_gmt":"2016-10-06T11:38:25","guid":{"rendered":"http:\/\/www.fastwebhost.in\/blog\/?p=428"},"modified":"2019-01-22T08:08:52","modified_gmt":"2019-01-22T08:08:52","slug":"create-manage-mysql-databases-cpanel","status":"publish","type":"post","link":"https:\/\/www.fastwebhost.in\/blog\/create-manage-mysql-databases-cpanel\/","title":{"rendered":"How to Create and Manage MySQL Databases from cPanel?"},"content":{"rendered":"

There are two ways that allow us creating MySQL Databases from Cpanel.<\/p>\n

1. MySQL Databases from Menu <\/p>\n

2. MySQL Database Wizard<\/p>\n

1. Creating a database from MySQL Databases from cpanel menu<\/h4>\n

1.1 To create Database(s) log Into cPanel \u2014-> Click on the MySQL Databases menu In the Databases section:<\/p>\n

\u200b<\/p>\n

\"MySQL<\/span><\/p>\n

1.2 Search for “Create New Database” section, then provide name of the database and click on “Create Database” button.<\/p>\n

\"MySQL<\/span><\/p>\n

1.3 Once database created and ready to use,Then we need to create MYSQL user and assign database to that user with appropriate privileges.<\/p>\n

To create a MySQL User,search MySQL Users and Add New User section and choose the username you wish to assign to your database. Makesure to set a secure password for MySQL User and fill the fields.<\/p>\n

\"MySQL<\/span><\/p>\n

We highly recommend to use password generator to create a secure password as shown below.<\/p>\n

\u200b<\/p>\n

\"Help<\/span><\/p>\n

1.4 After password set,click on the “Create User” button to finish the process as shown below image.<\/p>\n

\"MySQL<\/span><\/p>\n

1.5 It creates both MySQL Database from cpanel and MySQL user. We need to assign MySQL user to the database and assign privileges. Search for “Add User to Database” section and make sure that you set correct Database and User. Once done, simply click on the Add button just as it shows in below image.<\/p>\n

\"Adding<\/span><\/p>\n

In next window, you need to provide privileges to MySQL Users. As you suppose to provide full privileges to MySQL Users without any restrictions. For this just click on All Privileges and click “Make Changes” button as shown below Image.<\/p>\n

\"Assigning<\/span><\/p>\n

1.6 You will get the message showing the MySQL User is successfully add’s to the Database as shown below Image.<\/p>\n

\"Assigning<\/span><\/p>\n

To check if the database is created or not, simply go back and check in current Databases section. The below images represents the same.<\/p>\n

\"Confirmation<\/span><\/p>\n

2. Creating Database with the MySql Database wizard tool<\/h4>\n

MySQL Database Wizard brings the same step-by-step process which was explained in the step-1, but in a more simplified way. Let\u2019s start creating a Database.<\/p>\n

2.1 Log in to cPanel and click on the “MySql Database Wizard option” under Databases.<\/p>\n

\"Checking<\/span><\/p>\n

2.2 Give the name of the new database name and click on the Next Step button as below Image.<\/p>\n

\u200b<\/p>\n

\"Creating<\/span><\/p>\n

2.3 Now you need provide password for MySQL User as we done that earlier<\/p>\n

\u200b<\/p>\n

\"Creating<\/span>\"Generating<\/span><\/p>\n

2.4 After the username and password are given, simply click on the Create User button.<\/p>\n

\"Confirming<\/span><\/p>\n

2.5 Privileges should be assigned to the new MySQL User, just like we did in the last step.<\/p>\n

Accordingly, you will need to choose all Privileges option and click on the next step button.<\/p>\n

\u200b<\/p>\n

\"Assigning<\/span><\/p>\n

2.6 It gives you the confirmation message like adding the MySql user to the database.<\/p>\n

\u200b<\/p>\n

\"MySQL<\/span><\/p>\n

To verify if the database is created or not, simply go back and check on current database section.<\/p>\n

\"MySQL<\/span><\/p>\n

Conclusion<\/h5>\n

This article gives you the feasibility to create, edit and assigning privileges to the MySQL Databases from cpanel with a better graphical user interface. <\/p>\n","protected":false},"excerpt":{"rendered":"

There are two ways that allow us creating MySQL Databases from Cpanel. 1. MySQL Databases from Menu  2. MySQL Database Wizard 1. Creating a database from MySQL Databases from cpanel menu 1.1 To create Database(s) log Into cPanel \u2014-> Click on the MySQL Databases menu In the Databases section: \u200b 1.2 Search for “Create New […]<\/p>\n","protected":false},"author":9,"featured_media":470,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[22],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/428"}],"collection":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/comments?post=428"}],"version-history":[{"count":3,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/428\/revisions"}],"predecessor-version":[{"id":4677,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/428\/revisions\/4677"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/media\/470"}],"wp:attachment":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/media?parent=428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/categories?post=428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/tags?post=428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}