Hello there!
I am trying to setup a webuser to use for my php scripts to connect to the db.
I am having problems I tried this:
"Grant select,insert,update,delete
on mydb.*
to webuser identified by 'password';
I can use "webuser" and connect to the mydb using ODBC and MSAccess but if use the same "webuser" in my php scripts for my web pages it does not connect to mydb. I know that my php script is working okay because if I use the root as the user the scripts works fine,so it must be a privilege issue.
I am new to this, so forgive me if this is a dumb question.
I am trying to setup a webuser to use for my php scripts to connect to the db.
I am having problems I tried this:
"Grant select,insert,update,delete
on mydb.*
to webuser identified by 'password';
I can use "webuser" and connect to the mydb using ODBC and MSAccess but if use the same "webuser" in my php scripts for my web pages it does not connect to mydb. I know that my php script is working okay because if I use the root as the user the scripts works fine,so it must be a privilege issue.
I am new to this, so forgive me if this is a dumb question.