Creating a MySQL database and user Print

  • mysql, database, mariadb
  • 0

Most website applications, including WordPress, store their content in a MySQL (MariaDB) database. Creating one takes three steps: the database, a user, and the connection between them.

  1. In cPanel, open Databases › Manage My Databases.
  2. Under Create New Database, enter a name, for example shop, and click Create Database.
  3. Under MySQL Users › Add New User, enter a username and a strong password, and click Create User. Save the password; you will need it in the next step.
  4. Under Add User To Database, select the new user and database and click Add.
  5. Tick ALL PRIVILEGES and click Make Changes.

Connecting your application

SettingValue
Database hostlocalhost
Database nameYour cPanel username, an underscore and the name you chose, for example username_shop
Database userShown in the same format, for example username_shopuser
PasswordThe password you set in step 3
For security, databases accept connections only from websites on our server. If you need to connect from your own computer, please contact support.

Was this answer helpful?

« Back