Page 1 of 1

Could Not Connect to Database

PostPosted: 08. October 2010 15:11
by MyWorld
I downloaded a copy of my site and I'm trying to set it up on my computer. It's asking me for the database username and password. I entered the same one I used online but it's telling me "Could not connect to database. Please check your connection parameters." Where do I change/set the password?

I went to http://localhost/phpmyadmin/ but I don't see the option there.

I'm new to this so I'm a little lost. Thanks!!

Re: Could Not Connect to Database

PostPosted: 08. October 2010 15:36
by Altrea
MyWorld wrote:I entered the same one I used online but it's telling me "Could not connect to database. Please check your connection parameters."

sure, because the user does not exist on your installation.

MyWorld wrote:Where do I change/set the password?
I went to http://localhost/phpmyadmin/ but I don't see the option there.

- Login to phpmyadmin with your root user
- open the tab "privileges"
- create or edit the user you need

Hope that helps :D

Re: Could Not Connect to Database

PostPosted: 08. October 2010 16:26
by MyWorld
I seem to have gotten a lot closer Thanks! But I have a few more issues/questions.

When I need to add another copy of another site on my computer, do I still use phpmyadmin or do I need to create a new database?

Also I am having issues accessing the backend and the frontend:

The backend: The site was built using Joomla. When I enter the password and login, it takes me to the live site. So this is where I enter the login info http://127.0.0.1/foldername/administrator/index.php but when I'm logged in I see this: http://www.thelivesite.com/administrator/index.php

The frontend: It get an error that the component is not found.

Thanks alot - really appreciate your help!!

Re: Could Not Connect to Database

PostPosted: 08. October 2010 17:55
by Altrea
MyWorld wrote:When I need to add another copy of another site on my computer, do I still use phpmyadmin or do I need to create a new database?

phpmyadmin is just a configuration program (written mainly with php) for your MySQL DBMS. Your DBMS can hold several separate MySQL Databases.
Not every site need a Database (of cause Joomla needs one). To create a database you can use phpmyadmin, too!

MyWorld wrote:So this is where I enter the login info http://127.0.0.1/foldername/administrator/index.php but when I'm logged in I see this: http://www.thelivesite.com/administrator/index.php

Thats a Joomla configuration issue. Somewhere in your Joomla configuration you can change the base url (or something like that)

Re: Could Not Connect to Database

PostPosted: 10. October 2010 02:02
by MyWorld
I got it. Thanks so much!!