Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: paul bearne on November 02, 2002, 07:18:03 PM

Title: using mysql in an ibay
Post by: paul bearne on November 02, 2002, 07:18:03 PM

Hi

I am missing somethink here

I am tring to install a php app into an ibay that needs mysql

ok here what i have done

made the database use phpadmin ran the sql scipt that came with the app made all the tableand entered the default data

and created an user for the app and granted primissons the that user for the database

bu when i run the app it can't conect to mysql

the app db settings are


   $db_host = "localhost:/var/lib/mysql/mysql.sock";
   $db_port = "";
   $db_name = "recipedb";
   $db_user = "recipe";
   $db_password = "recipe";


I have tried

   $db_host = "localhost";

Any body got any ideas

paul

Title: Re: using mysql in an ibay
Post by: Nathan Fowler on November 03, 2002, 04:04:00 AM

Search the forum for the "grant" syntax, chances are you need to set permissions on the table to allow the user receipedb to connect to that particular database.

Title: Re: using mysql in an ibay
Post by: paul bearne on November 03, 2002, 01:41:33 PM

OK

I have worked out And adding it here to help some one else


If you use phpadmin donot grant Privileges to users a web user doesn't need them to work in fact they don't work

Anybody care to tell us why


paul