Jump to content


Photo

My SQL and Squirrel Cart


  • Please log in to reply
4 replies to this topic

#1 calvinmcdaniel

calvinmcdaniel
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 25 February 2006 - 03:41 AM

Totally new to MySQL. Just purchased a shopping cart called Squirrel Cart. It required setting up user name, password and database. I have followed the Squirrel Cart instructions to set these up and the database is created; however, the Squirrel Cart software cannot connect to mysql database when username, password and database are supplied.

Any suggestions how to resolve this. Would someone be willing to look at the config.htm from Squirrel Cart that was created to troubleshoot.

Thanks
Calvin

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 25 February 2006 - 04:39 AM

Hard to say -- if it's purchased software, you really should contact their tech support, since they'd be the most familiar with config issues. Do you have any trouble connected from, say, a PHP script?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 25 February 2006 - 08:42 AM

It's possible that you forgot to add the correct user privileges in MySQL. See [a href=\"http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.0/en/use...management.html[/a]

#4 calvinmcdaniel

calvinmcdaniel
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 25 February 2006 - 01:01 PM

That's true. After creating the database, I added "Grant all privileges *.* to 'calvinmcdaniel'@'localhost' identified by 'perrydog;

I've read a couple articles about mysql adding prefixed to usernames and another about not using the ' around password.

Squirrel Cart support hasn't really helped. They say it has to be something with mysql.

In their config file store.php, it wants you to add the following :

$sql_host = 'localhost';

$sql_username = 'calvinmcdaniel';
$sql_password = 'perrydog';

$db = 'c:\program files\mysql\mysql server 5.0\data\framedata;

Do these look correct. Framedata is the name of my database to connect to.

Thanks
Calvin

#5 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 25 February 2006 - 04:43 PM

$db = "framedata"; MySQL will know where to look for the actual file.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users