How to create a MySQL Database?

Before you can use a MySQL database you need to create it and a user to access it. You can do this from your Hosting control panel. When you create a database and username your Hosting control panel automatically prefixes them with your Hosting control panel username. Follow the steps below, replacing "user" with your Hosting control panel username.
 
  1. Log into your CPanel
  2. On the CPanel homepage, look for the MySQL Databases icon under the Databases tab
  3. Enter the database name in the New Database field
  4. Click Create Database
  5. Under Add New User type the username and a password and click Create User
  6. Under Add User To Database select the username and database and click Submit
  7. Select the permissions you would like to give to that user and click Make Changes
 
Now use the following details to connect to the database:
 
Server: localhost
User: user_me
Database: user_db
Password: The password you entered when you created user_me

Was this answer helpful?

 Print this Article

Also Read

Money Back Guarantee

If you are unhappy with your Business Web Hosting service with us for any reason or just wish to...

墨尔本网站设计,墨尔本电子商务,墨尔本网站托管(Melbourne Web Hosting Chinese)

澳宝网络旗下网站 AusDomains.com.au 墨尔本中小企业电子商务解决方案!...

How to change Your FTP Password?

It is a good idea to regularly change your password. You should always change your password if...

How to create Email accounts?

You can set up as many POP3 email accounts as you require, up to the maximum limit set for your...

Can I upgrade my hosting plan at a later date?

Yes, you certainly can upgrade your hosting plan at a later date if you find yourself hitting...

Powered by WHMCompleteSolution