MySQL is an open-source relational database management system. It is often bundled with other software to run websites and web applications. It is installed with the Apache HTTP server and the PHP language in software stacks like LAMP (Linux, Apache, MySQL and PHP) and WAMP (Windows, Apache, MySQL and PHP). It is used by Content Management Systems like WordPress, Joomla and Drupal.
1. Log in to the cPanel of your web host.
2. Scroll down the page to the group of software with the subheading Databases and select MySQL Databases.
3. The MySQL Databases page will appear. Type in the name for your new database under Create New Database and then click on Create Database.
4. Click on Go Back.
5. Scroll down the page to MySQL Users. Type in the username and password for your new database, and then click on Create User. Remember the username and password as you will be needing them in your website maintenance.
6. Click on Go Back.
7. Scroll down the page to Add User To Database. Choose your newly created username and database from the dropdown lists below User and Database, and then click on Add.
8. A new page titled Manage User Privileges under MySQL Databases will appear. Tick the checkbox for ALL PRIVILEGES and then click on the Make Changes button.
9. Click on Go Back. It’s finished.