How to create a database?

Posted December 1, 2015

In this tutorial, we will be using MySQL Database Wizard to create your database and a database user. It's more secure to have a separate MySQL user for each of your databases rather than using your cPanel username.

To get started, follow these stesps.

1. Log into your cPanel account.

2. Click the MySQL Database Wizard icon.

3. Give your database a name. For example, mydata

4. Next, provide a database user name and a strong password. Let's say, myuser. It's better to generate a random password for extra security.

5. Next, give access privileges to your database user. Select only those that you need for your queries. Click Next Step.

6. You're done!


Make sure to take note of your database username, name and password as you will be needing them for your applications. 

Notice that both your database username and name have your cPanel username prefix. Do not forget about that as well.

Related articles
  Terms of Service (Customer Agreement)
  How to pay online for your digital goods?
  How to secure my website and emails?
  CPU, Disk I/O and Memory (Resource Usage Policies)
  Unmetered Disk Space & Bandwidth (Resource Usage Policies)
  What is an addon domain and how to use it?
  How to check my email using an email client like Outlook or Thunderbird?
  How to clear your DNS cache?
  Terms of Service (Privacy Policies)
  Emails (Resource Usage Policies)
  Backups (Resource Usage Policies)
  How to backup & restore my databases?
  How to fix Google malware warning?
  How to fix 500 Internal Server Error?
  How to upload files using FTP?

« Go back

Do not reproduce or distribute articles without proper permission or attribution (link to Hanep Hosting).

Powered by Help Desk Software HESK, brought to you by SysAid