homepage Welcome to WebmasterWorld Guest from 54.161.214.221
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Need help setting up script
geoclassfied
halcyonlost




msg:3132456
 1:47 am on Oct 24, 2006 (gmt 0)


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




msg:3132468
 1:53 am on Oct 24, 2006 (gmt 0)

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




msg:3132560
 4:53 am on Oct 24, 2006 (gmt 0)

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




msg:3132587
 5:23 am on Oct 24, 2006 (gmt 0)

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




msg:3133753
 11:42 pm on Oct 24, 2006 (gmt 0)

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]

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved