Creating a MySql Database

If your website uses PHP or you need to hold a collection of records which need to be accessed for parts of your website to work, you will need to create a database. * * * The first step is to log into your cPanel account. If you are unsure on how to do this, please view the following help article - '[How to log into cPanel](https://hostpresto.com/help/article/1)'. ![alt text](https://i.imgur.com/QRmld56.png "Creating MySql database 1") * * * Scroll down to the '**Databases**' section and choose '**MySQL Database Wizard**'. ![alt text](https://i.imgur.com/h8MP0Jc.png "Creating MySql database 2") * * * The first step is to write in a database name where '**New Database**' is shown. This name will be prefixed on the end of your account name. ![alt text](https://i.imgur.com/bYuDWy2.png "Creating MySql database 3") * * * Select '**Next Step**' button to continue. ![alt text](https://i.imgur.com/iVRSfy6.png "Creating MySql database 4") * * * You now need to set up a database username and password. Type in: * **Username** - the username for the database user. * **Password** - password for the database user. You can take advantage of the 'Password Generator' option if this helps. * **Password (Again)** - repeat of the password. > You may wish to note down your database name, the database username and password. ![alt text](https://i.imgur.com/Ke4jhwz.png "Creating MySql database 5") *** Once the database user information has been completed, select '**Create User**' button to proceed. ![alt text](https://i.imgur.com/BG5VXmE.png "Creating MySql database 6") * * * You now need to choose the database user privileges according to your requirements (usually 'all privileges'). ![alt text](https://i.imgur.com/J7ZKCTY.png "Creating MySql database 7") *** Once the privileges have been set, choose '**Next Step**' to complete the process. ![alt text](https://i.imgur.com/qJ2IMlZ.png "Creating MySql database 8") *** You will now see visual confirmation that the database has been created. ![alt text](https://i.imgur.com/FuAE59H.png "Creating MySql database 9") Creating a MySQL database is now complete. * * *
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to log into cPanel

There are two different methods to log into your cPanel control panel in order to manage every...

What's the difference between Aliases, Addon and Subdomains?

### Aliases An Alias domain does not have a unique website. It is a domain that is masked to...

Importing a MySql Database

You can import a MySQL database via phpMyAdmin which is available in the cPanel control panel....

Exporting a MySql Database

You can export a MySQL database via phpMyAdmin, available in cPanel, if you want to keep a backup...

Viewing your Web Stats

Web Stats for your website are important to determine everything about the visitors to your...