There are two ways to Create MySQL Databases:<\/p>\n
1. In order to start, log into cPanel and click on the MySQL Databases menu in the Databases section 1. To find the tool, log into cPanel and click on the MySQL Database Wizard<\/strong> option under Databases<\/strong> And you are Done!.<\/p>\n","protected":false},"excerpt":{"rendered":" Manage MySQL On cPanel Account There are two ways to Create MySQL Databases: MySQL Databases menu MySQL Database Wizard Creating a database from the MySQL Databases menu 1. In order to start, log into cPanel and click on the MySQL Databases menu in the Databases section 2. Once there, find the Create New Database section, […]<\/p>\n","protected":false},"author":2,"featured_media":290,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25,5],"tags":[4,26],"_links":{"self":[{"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/posts\/289"}],"collection":[{"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/comments?post=289"}],"version-history":[{"count":4,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/posts\/289\/revisions"}],"predecessor-version":[{"id":1287,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/posts\/289\/revisions\/1287"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/media\/290"}],"wp:attachment":[{"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/media?parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/categories?post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/tags?post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n 2. Once there, find the Create New Database<\/strong> section, then simply indicate name of the future database and click on the Create Database<\/strong> button
\n 3. The database is created and ready to use. Now, in order to be able to fill and maintain the database, MySQL User should be created and assigned to the database with correct privileges. To create a MySQL User, find the section called MySQL Users<\/strong> > Add New User<\/strong> and choose the username you wish to assign to your database. Once done, choose a secure password for MySQL User and type it into the corresponding fields
\n It is highly recommended to use the built-in Password Generator<\/strong> to create a secure password as shown below or type a strong password or try Strong Password Generator<\/a> Or Cloudwards Password Generator Tool<\/a>
\n 4. After the password is chosen, simply click on the Create User<\/strong> button to finish the process
\n 5. Now you have both MySQL Database and MySQL User created. Now we need to assign MySQL User<\/strong> to the database and set proper privileges. To do this, find the Add User To Database<\/strong> section and make sure that you choose the correct Database and User correspondingly. Once done, simply click on the Add<\/strong> button
\n 6. In the next window you will need to set correct privileges to the MySQL User. In this example, we shall grant all privileges to be able to maintain our MySQL Database without any restrictions, so you simply need to choose the All Privileges<\/strong> option and click on the Make Change<\/strong>s button
\n NOTE: <\/strong>It is important to remember that multiple MySQL Users with different sets of privileges can be assigned to the same MySQL Database.
\n 7. Once finished, you will get the message stating that the MySQL User was successfully added to the Database<\/p>\nCreating database with the MySQL Database Wizard tool<\/h2>\n
\n 2. Once done, indicate the name of the new database and click on the Next Step<\/strong> button
\n 3. At Step 2 you will be prompted to indicate MySQL User<\/strong> and choose a password<\/strong> for it, reciprocally to the process described before
\n 4. After the username and password are indicated, simply click on the Create User<\/strong> button
\n 5. The next windows will allow you to set privileges for the newly created MySQL User similarly to the process described previously.
\n 6. Once done, you will get a confirmation that the MySQL User was successfully added to the MySQL Database<\/p>\n