create database problem (and almost solution!)
hi guys, thanks for the help with my last query.
I'm sort of up and running now with mySQL on WinXP. While I can do lots with mySQL I seem unable to create a new database so I'm currently stuck with the test one.
I get an: Error 1044: Access denied for user: '@localhost' to database...
when I try and create a new db. I think (thorugh some fishing about) that its because I have not set a password on mySQL root (what is root by the way).
I tried to do this but failed. is there an easy way to do this or get round this problem. I'm working off localhost
thanks so much