Need help setting up script

geoclassfied

[halcyonlost]

Hey Guys,

Im not even going to pretend to know about this stuff so bare with me.

I am trying to set up a classified program using geoclassfied lite. I setup MySQL with user name and password and gave it full access to the database.

The guide then tells me to change data in my config.php. I change it and save it to the site and when the program trys to connect to database, it gives me an error(unable to connect to the database).

Here is what it said in the config.php:

$db_host = "localhost";//location of sql host - usually localhost
$db_username = "mikecook";//username used to connect to database
$db_password = "#*$!#*$!X";//password used to connect to database
$database = "geoclassifieds";//name of database

The sad thing is, its telling me what to do but Im still not getting it. Any help would greatly be appreciated.

[eelixduppy]

Two things I would check first.

1) Make sure your MySQL Server is started and running properly. :)

2) Make sure that you truly did follow all the directions accurately. I'm sure there is a troubleshooting section in the documentation if that will help; personally I'm not familiar with it.

Good luck!

[added]
Depending on what version of MySQL you have, you may not have a compatible password. Here's some information [dev.mysql.com].
[/added]

[phparion]

database name is case sensitive make sure you are using the correct names, also write a simple page just to check db connection and run it and see if it connects you to the db.

last thing you could check is to check the username and password of the database and host info is correct...

[halcyonlost]

Thanks for the ideas. I checked everything and it is still not working. What exactly would be the name of my database, Would I do, www.blank.com/geoclassifieds or just geoclassifieds. Its got to be something like that im missing...

[Knowles]

It would just be "geoclassifieds" however as mention it is case sensitive so make sure its not GeoClassifieds or that you did make it plural.

Also verify with your host that the MySQL host name is localhost. Some hosts run separate servers for MySQL.

[edited by: Knowles at 11:43 pm (utc) on Oct. 24, 2006]