Studyhost - Simple web hosting solutions

dollar

pound

Portal Home > Knowledgebase > Databases (MySQL) > How do I connect to and use MySQL?


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.



Was this answer helpful?

Print this Article Print this Article

Also Read
What is MySQL? (Views: 1207)