New Database MySQL

[Fourx]

Hi

Just started Database driven Website book and installed mysql, php & iis etc.

Can log in to mysql and view database and even drop the existing database I created some months ago but when I try to create a new database it will not complete the task.

error message:

ERROR 1044 (42000): Access denied for user ''@'localhost to database 'test'

Tried everything I can think of but no success.

If someone could help it would be really appreciated.

[Snerdey]

Looks like a simple config error. Most hosting companies will actually guide you a little sometimes. I know ours does the guys bend over backwards to troubleshoot things like this.

It's communicating with the database until it gets to the user / password to me.

You can also add a simple log command in .htaccess so you can view the errors and get a better idea of what's happening.

If your not used to that.. just ask your hosting company. It's no biggie and should be a snap to get that going.

[codealready]

check the permissions for the user. sometimes the host will probide a program like phpmyadmin to easily manage the database.