How do I connect to and use MySQL?

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 passwd: 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.

  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

What is MySQL?

MySQL is a very robust database server. It is often used to deliver dynamic content to sites such...

Can I connect remotely to MySQL database?

Yes! it is possible. For this you have to allow remote access from your control panel, by adding...