How and where to add database...

[TheJoker]

help guys... i'm building database using PHP... and i have a database name jobs.db... with table...

where could i upload it and how to access it when uploaded here...

thanks a lot...

 

[kajasweb]

You should create your MySQL Databases first in order to create tables in it and use.

To create MySQL databases.
- Login to cPanel.
- Navigate to MySQL Databases.
- Create a database (if you give the database name as DB, the database will have the name yourcpanelusername_DB)
- Create a MySQL User (if you give the user name as user, the username will be yourcpanelusername_user)
- Add the user to the database you just created & assign permissions for the user.

You now have the MySQL Database and Username to access it.

Here are the details to connect to MySQL from your PHP Script
Host - localhost
Username - yourcpanelusername_mysqlusername
Password - <password you have given during creation of MySQL User>
Database - yourcpanelusername_databasename

Hope, this will help you.

All the best.

 

[Jarryd]

Also, if you are familiar with PHPMyAdmin you can use that, it's quite a good little tool to use.

 

[kajasweb]

Usually, web-hosts won't allow members using phpMyAdmin to create databases. You have to use cPanel for adding databases to your account.

 

[mr kennedy]

Well hosts with cPanel like x10 allows you to create a db with PMA but PMA is somehow limited like your not allowed to dload a backup through the 'Export'

 

[kajasweb]

Hmmm.. But, I just saw "No Privileges" message in PMA > Databases > Create Database.

 

[Jarryd]

I created all my databases in PMA, but i can't export like he said.