I have apache v1.3.27, PHP 4.3.2 MySQL 3.23.49 installed on Solaris.
The installation seems to be fine as i can successfully use mysqladmin, mysql commands to log onto my databases and do manipulation on the Solaris box.

But trying to access the database from Windows IE i get the following error:
1044: Access denied for user '@localhost'n to database 'name of database'.

Any help appreciated.
Thanks

during login you might not given any username

the syntax is
mysql_connect($dbhost,$dbuser,$dbpass);

you can try the following example but I am not sure whether it will work or not as I don't know ur username & password.

$handler=mysql_connect('localhost','root','');
if($handler) echo "Connection success"; else die(mysql_error());

Best Regard:
Md. Zakir Hossain (Raju)
www.rubd.net
www.xenex.rubd.net
www.forum.rubd.net

ajuta,

execute mysql from the shell ( you indicated that it worked that way) and issue the following command:

GRANT ALL PRIVILIGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'password';

Alternatively, to par down permissions,

GRANT ALL PRIVILIGES ON <Database Name>.* TO 'user'@'localhost' IDENTIFIED BY 'password';

  This is a relatively common problem/mis-configuration. I just spent some time banging my head wondering why my code wasn't working when I rememberd I did that on the DEVELOPMENT server but not the PRODUCTION server. oops.

Regards,
Meredith Shaebanyan

Thanks, I did set up my password by using :
"set password for root@loacalhost=password('your_password');
log out "\q", and then log back with:
mysql -u root -p,
prompts for password! 'yourpassword'
and then I get the wellcome monitor screen.
then I make sure I place the same password in my PHP script, at hte
mysql_connect () function.
and I now get : Can't create database 'wiley'. Database exists.
My hole next week will be dvoted to this message NOW..