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

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.

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.

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.

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.

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

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 🙂

See you on other post and stay health!