my sql

[labratza]

how do you connect to a mysql database???? i am trying to get my site up and going on freeweb7.com and yeah i have created my sql database and when i try connecting to it then it keeps telling me that i have entered an incorect username and password i am using joomla as my interface so any help would be grateful

 

[chiskop]

how do you connect to a mysql database???? i am trying to get my site up and going on freeweb7.com and yeah i have created my sql database and when i try connecting to it then it keeps telling me that i have entered an incorect username and password i am using joomla as my interface so any help would be grateful

Joomla needs to know the database location (usually localhost), the db name, the db user, the db password and (optionally) a prefix.

I would imagine that the problem is most likely to be an incorrect location or db name. Check that your host isn't adding your account name to the db name, for example you set up a db called joomla, it sees it as labratza_joomla.

Ah - that is what they're doing: http://freeweb7.net/showthread.php?t=1 - scroll down to How to connect to PHPMyAdmin?, but also look at I can't install modules to Joomla or Mambo, why?

 

[Kasyx]

You need to find the configuration file in the joomla directory (can't remember the exact name, but it is something like config.php or something). Open it in notepad and make sure that the mysql username and password are the ones you set, and that the database name and location are correct.

 

[chiskop]

configuration.php - but it won't have been written yet.

 

[RSkeens]

Hi labratza,

Chiskop is right - you may be simply missing the database (and username) prefix that is based off your login name, as these are used in shared environments.

Also please bear in mind that there is a strict character limit on both database name and database username, therefore to be absolutely certain you would need to gather the exact database name and database username from your control panel's database manager.

Good luck!