{"id":283,"date":"2023-02-26T14:02:55","date_gmt":"2023-02-26T14:02:55","guid":{"rendered":"https:\/\/blog.webystrata.co.uk\/?p=283"},"modified":"2023-02-26T14:02:55","modified_gmt":"2023-02-26T14:02:55","slug":"my-sql-database-wizard-cpanel","status":"publish","type":"post","link":"https:\/\/www.webystrata.co.uk\/blog\/my-sql-database-wizard-cpanel\/","title":{"rendered":"My SQL Database Wizard -cPanel"},"content":{"rendered":"

MySQL Database Wizard is a step by step process to create a MySQL database and user and finally adding the user to access the database.<\/p>\n

To use this interface, we will need to open MySQL Database Wizard, which can be found in the database section of cPanel Home, as shown below.<\/p>\n

\"MySQL<\/p>\n

Step 1<\/strong>\u00a0\u2212 Create a New Database by providing a Database Name in the text input, once filled, click\u00a0Next Step<\/strong>.<\/p>\n

\"Database<\/p>\n

Step 2<\/strong>\u00a0\u2212 Create Database user by providing a username and Password. Click\u00a0Create User<\/strong>\u00a0when done.<\/p>\n

\"Create<\/p>\n

Step 3<\/strong>\u00a0\u2212 Add user to the database by granting all the privileges to the user for accessing and modifying the data. Select ALL PRIVILEGES checkbox and click Next Step, when done.<\/p>\n

\"Add<\/p>\n

Step 4<\/strong>\u00a0\u2212 You will get a success message if everything works fine.<\/p>\n

To modify the database created using MySQL Database Wizard, you can always use MySQL Databases interface.<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL Database Wizard is a step by step process to create a MySQL database and user and finally adding the user to access the database. To use this interface, we will need to open MySQL Database Wizard, which can be found in the database section of cPanel Home, as shown below. Step 1\u00a0\u2212 Create a […]<\/p>\n","protected":false},"author":1,"featured_media":284,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[12],"class_list":["post-283","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel-complete-tutorials","tag-cpanel-complete-tutorials"],"_links":{"self":[{"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/posts\/283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=283"}],"version-history":[{"count":1,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/posts\/283\/revisions"}],"predecessor-version":[{"id":285,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/posts\/283\/revisions\/285"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/media\/284"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}