mysql connect problems on linux

[Immyphp]

I had an awful time trying to set up mod_auth_mysql on a windows environment, so i set up a lamp server

using ubuntu

i decided to test it using code i have had working in a windows environment,

and i had this error when trying to authenticate with mysql

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'webauth'@'localhost' (using password: YES) in /var/www/secretdb.php on line 19
Cannot connect to database.

i think the problem is i dnt have read or write permissions to change the mysql data folder. i do not know where it is its just a hunch,

has anyone had this problem before? would anyone know how to fix it🙂

thank you for your help i can put all the code ive used including the mysql code here if need be 🙂

[bradgrafelman]

It shouldn't have anything to do with file permissions. Are you sure that you setup a 'webauth' user in MySQL with the correct password?

[Immyphp]

hey thanks for the reply,

i should of updated my status, i have not solved the problem but i did get closer, i found 1 were both on the same track its definitley not a file permission problem.

2. i can get my web pages to access the sql database if use a global or root user of some kind in my web code.

i think the problem im having is geting my mysql to grant the select privilege on just one table. and using that to log in

heres the code im using in mysql

grant select on auth.* to 'webauth' identified by 'webauth; ;
flush privileges;

thanks for your help with this