I keep getting this msg

access denied for user:'daniel@demo' (using password:YES)

the user name & password is all correct

i'm using oscommerce & trying to create a data base.

this is done on my own test server (using apache server, php, mysql)

pls help me to configure mysql

thanks

do you have permissions to create a database with that user? check out your grant table.

well i'm not sure bout this. this is my first time setting up mysql
where do i look for this?

try searching google for the mysql statement grant priviledges(i hope i spelled it right).

As guelphdad said, its probably permisions, check out the Mysql site for more info on the GRANT command.

Also try loging onto the database manualy with the same username and password.

Although i am confused, you are running this locally, so i assume you set up the user 'daniel', so you would of used the GRANT command to specify permissions then, and also should the @demo bit, be @localhost, just thinking maybe you didnt change it from the oscommerce default one or something.