Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: Stone Linton on March 02, 2001, 09:02:02 PM
-
I'm trying to set this up on my e-smith 4.1 box. So far, I've created an ibay called 'webshop' and then followed the instructions to the best of my understanding, using my /home/e-smith/files/ibays/webshop/html as my web server root, and ..webshop/demo as my WEBROOT -- per my interpetation of the instructions.
Any of you familar with getting phpShop up and running? I saw some earlier posts.
As it is now, I get the following message on my attaching client:
Warning: Host 'hostname.domain.com' is not allowed to connect to this MySQL server in /home/phpshop/db/db_mysql.inc on line 73
Database error: connect(hostname,root,PASSWORD) failed
MySQL Error: ( )
I know nothing of PHP or MySQL so respond accordingly . . . please. Thanks.
-
"Warning: Host 'hostname.domain.com' is not allowed to connect to this MySQL server in /home/phpshop/db/db_mysql.inc on line 73
Database error: connect(hostname,root,PASSWORD) failed
MySQL Error: ( )"
You need to setup a user in on mysql that has right to your database...
mysql>grant all on databasename.* to username@localhost identified by 'password';
alternatively... you haven't setup your dbuser entry correctly on your application!
Brandon
-
When you created the mysql user, you probably specified localhost (dbuser@localhost). If this is the case, you need to tell phpShop to connect to "localhost", not "hostname.domain.com", for the MySQL server. This will probably fix your problem.
-
Thanks. That was it. I was about two hundred pages in to MySQL's manual . . . looking for answers and not understanding a thing!