calvinmcdaniel Posted February 25, 2006 Share Posted February 25, 2006 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.ThanksCalvin Quote Link to comment https://forums.phpfreaks.com/topic/3582-my-sql-and-squirrel-cart/ Share on other sites More sharing options...
fenway Posted February 25, 2006 Share Posted February 25, 2006 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? Quote Link to comment https://forums.phpfreaks.com/topic/3582-my-sql-and-squirrel-cart/#findComment-12401 Share on other sites More sharing options...
wickning1 Posted February 25, 2006 Share Posted February 25, 2006 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] Quote Link to comment https://forums.phpfreaks.com/topic/3582-my-sql-and-squirrel-cart/#findComment-12405 Share on other sites More sharing options...
calvinmcdaniel Posted February 25, 2006 Author Share Posted February 25, 2006 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.ThanksCalvin Quote Link to comment https://forums.phpfreaks.com/topic/3582-my-sql-and-squirrel-cart/#findComment-12419 Share on other sites More sharing options...
wickning1 Posted February 25, 2006 Share Posted February 25, 2006 $db = "framedata"; MySQL will know where to look for the actual file. Quote Link to comment https://forums.phpfreaks.com/topic/3582-my-sql-and-squirrel-cart/#findComment-12434 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.