Topic: using mysql in an ibay

[paul bearne]

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

[Nathan Fowler]

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.

[paul bearne]

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