1. Guarantee Web site malware removal (joomla, drupal, wordpress etc) - don't let your business get down due to virus, malware and blacklist problem.
  2. Recommended Web Hosting to help you doing business online with high performance. : Support ioncube, zend and all other hosting by default.
  3. Get free wordpress website transfer : up to 4 domains Find out more .... Click here to see other user testimonial

After migrating around 100++ website that use wordpress as their engine I realize one thing :

sucuri long How to create / add database on Hostgator

wrdp1, wrdp2 etc

I don’t know where its come from until I try installer that exist on cpanel like fantastico or simplescripts. Yes, using that facility will automatically create database with that naming convention.

How do I create database with special name on my hostgator account?

That question came from one client who want to install special php script that not available from fantastico neither on simplescripts.

You can create yourself using this steps :

1. Login to your hostgator account

2. Scroll down and look for Databases section.

Click on MySQL Databases icon.

hg create db1 How to create / add database on Hostgator

3. Create database name

Database name, by default system only allow 7 characters for database name. Make sure to enter easy to use name. For example if you want to use database name for domain :

christmasgiftideas2011.com you can enter

xmasgift

as name of database.

hg create db2 How to create / add database on Hostgator

Hit Create database and system will automatically create it.

For example :

Added the Database hformul_xmasgift.

4. Create database user

Tips : use the same name for db user.

enter :

xmasgift

as username

Click Password Generator button.

Followed by click Create User button.

hg create db3 How to create / add database on Hostgator

Until this step you have database user with the same name as your database name.

5. Add user to mysql database

Choose user and database from drop down menu and click Add button.

hg create db4 How to create / add database on Hostgator

Click “All Privileges” as wildcard for checking all option automatically.

hg create db5 How to create / add database on Hostgator

Hit Make changes button will give you this message.

User “hformul_awcrap” was added to the database “hformul_awcrap”.

6. Finish

At this stage you have these data for database setting option for your php script :

- Database name

- Database user

- Password for database user

Host for this setting is ‘localhost’.

Simple as 123 icon smile How to create / add database on Hostgator

See you on other post and stay health!

 

hg How to create / add database on Hostgator

Related posts:

  1. How to add database on Parallels Plesk Panel
  2. How to Create Weebly Account and Use Own Domain
  3. Step by step move drupal from localhost to drupal hosting : AddOn Domain Setting
  4. How to add new domain on Hostgator Shared Host
  5. Download failed.: Could not create Temporary file

Sorry, the comment form is closed at this time.

   
© 2011 Hosting Formula Suffusion theme by Sayontan Sinha