How to Create a New MySQL Database in cPanel?

MySQL is a database management system used to store, manage, and query data in an organized manner. MySQL is supported by popular content management systems such as WordPress, Joomla, and Drupal, and is widely used around the world. To create a MySQL database in cPanel, you can follow the steps below.

  • Access the website www.fastpanda.co.uk
  • Click on the “Sign In” button on the opened page, enter your customer panel information, and click the “Log in” button to log in to your account.

  • Click on the “Web Hosting” option in the left menu.

  • On the opened page, you will see your existing web hosting packages. Click the “Manage Product” button for the service you want to access cPanel.

  • You will see a “Login to cPanel” button. Clicking on this button will automatically redirect you to cPanel.

  • On the cPanel home page, under the “Databases” section, click on the “Manage My Databases” option.

Managemydatabases

  • On the “MySQL Databases” page, go to the “New Database” section. Enter a name for the new database. Avoid using special characters in the database name. After deciding on the database name, click the “Create Database” button.

createdatabase

  • After creating a new database, you need to assign a user to this database. Access the “Database Users” section on the same page. Fill in the username and password fields located just below the “Add New User” heading. Avoid using special characters in the database username. Once you are sure of your password and username, click the “Create User” button. The database user will be created after this step.

database users

  • After the above steps, you need to assign the database user to the database. In the “Add User To Database” section, select the username and the database. Click the “Add” button.

addusertodatabase

  • On the opened page, check the “ALL PRIVILEGES” option to grant all privileges to the user and click the “Make Changes” button.

allprivileges

  • After completing all the steps, the new MySQL database will be ready for use. You can check the database and assigned user information in the “Current Databases” section of the Manage My Databases page.

currentdatabases