Please login to your control panel and follow these steps to create the database, user and its password:
Once you login into your control panel, please click on "MySQL Databases" under "Database" section and then
a) Use the option "Create MySQL database" to create the database,
say "dbname". The database name will have your username as its prefix
username_ i.e. username_dbname
b) Create a database user from the same interface and note down the username and password, say username_user
c) Grant ALL privileges to this user on the database created using
the option "Grant permissions on a MySQL database to a MySQL user"
Now you have following ready:
Database: username_dbname
DB user: username_user
DB user password: XXXXXX (this is what you setup in step b)
host: localhost
Now you can use these values in your php or perl script to connect it to the database.
To browse your database, you can click on phpMyAdmin in your control panel.
- 57 Users Found This Useful
Related Articles
What is MySQL?
MySQL is a very robust database server. It is often used to deliver dynamic content to sites...
Can I connect remotely to MySQL database?
Yes! it is possible. For this you have to allow remote access from your control panel, by...
How do I create/delete/edit my databases and users?
All administration of your MySQL databases and users can be done through our convenient web...
Which version of MySQL is available?
The shared/reseller servers are setup with MySQL 5.2.x. If you need to use newer version i.e....
