Jump to content

Archived

This topic is now archived and is closed to further replies.

calvinmcdaniel

My SQL and Squirrel Cart

Recommended Posts

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

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.