{"id":4068,"date":"2019-10-29T17:13:04","date_gmt":"2019-10-29T09:13:04","guid":{"rendered":"https:\/\/www.mondoze.com\/guide\/?post_type=kb&p=4068"},"modified":"2022-10-05T07:56:32","modified_gmt":"2022-10-04T23:56:32","slug":"how-to-create-mysql-database-in-cpanel-with-mysql-database-wizard","status":"publish","type":"kb","link":"https:\/\/www.mondoze.com\/guide\/kb\/how-to-create-mysql-database-in-cpanel-with-mysql-database-wizard","title":{"rendered":"How to Create MySQL Database in cPanel with MySQL\u00ae Database Wizard"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

How to Create MySQL Database in cPanel with MySQL\u00ae Database Wizard<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

1. Assuming you are in cPanel, click on\u00a0MySQL\u00ae Database Wizard<\/b>\u00a0icon under\u00a0Databases<\/b> group.\u00a0<\/p>

\"\"<\/p>

Default page<\/p>

2. Insert your database name in the provided field and click\u00a0Next Step<\/b>. (No special character and no more than 8 characters are allowed)<\/p>

Default page<\/p>

\"\"<\/a><\/p>

3. Enter the database user and password you want to use for this database in the given text boxes respectively. Click Next Step to continue.<\/p>

\"\"<\/p>

4. At this stage, you may need to assign the privilege to this MySQL user . The top of the table provides a checkbox option “ALL PRIVILEGES<\/b>” allowing you to create the database with all privileges, otherwise choose the available privileges in the two columns. Click\u00a0Next Step<\/b>\u00a0and you are done.<\/p>

You could check the options descriptions below.<\/p><\/thead>
SELECT<\/b><\/td>To select data from a table in the database.<\/td><\/tr>
INSERT<\/b><\/td>To insert data into a table in the database.<\/td><\/tr>
UPDATE<\/b><\/td>To update data in a table in the database.<\/td><\/tr>
DELETE<\/b><\/td>To delete data from a table in the database.<\/td><\/tr>
INDEX<\/b><\/td>To create index on table column in the database. This can speed up a database.<\/td><\/tr>
CREATE TEMPORARY TABLES<\/b><\/td>To create temporary tables in the database.<\/td><\/tr>
CREATE<\/b><\/td>To create tables in the database.<\/td><\/tr>
ALTER<\/b><\/td>To alter tables in the database.<\/td><\/tr>
DROP<\/b><\/td>To drop tables in the database.<\/td><\/tr>
LOCK TABLES<\/b><\/td>To lock tables in the database.<\/td><\/tr>
REFERENCES<\/b><\/td>To create references to a table in the database.<\/td><\/tr>
CREATE ROUTINE<\/b><\/td>To stored routine creation<\/td><\/tr><\/tbody><\/table><\/article>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

How to Create MySQL Database in cPanel with MySQL\u00ae Database Wizard 1. Assuming you are in cPanel, click on\u00a0MySQL\u00ae Database Wizard\u00a0icon under\u00a0Databases group.\u00a0 Default page 2. Insert your database name in the provided field and click\u00a0Next Step. (No special character and no more than 8 characters are allowed) Default page 3. Enter the database user …<\/p>\n

How to Create MySQL Database in cPanel with MySQL\u00ae Database Wizard<\/span> Read More \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}}},"kbtopic":[],"kbtag":[110],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/4068"}],"collection":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/comments?post=4068"}],"version-history":[{"count":12,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/4068\/revisions"}],"predecessor-version":[{"id":17892,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/4068\/revisions\/17892"}],"wp:attachment":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/media?parent=4068"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=4068"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtag?post=4068"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=4068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}