I'm setting up a local webserver.
So I installed Apache and PHP.
These work fine.

But now I want to install mySQL so I can use databases.

So I installed mySQL (v3.23 I think) and started the server with (mysqld --standalone).
After that I start mysql with the command mySQL of course:D and try to use the standard database called mysql where all the login settings are(I need this for adding a user for php).But I get this error message: ERROR 1044: Access denied for user: '@localhost' to database 'mysql' .
What could be the problem?

Hope someone can help me.

login with the default username and password, root and blank.

c:\>mysql -u root -p

Then it asks you for a password, and just press enter since the default password is blank.

Obviously, if this database is on the web, you should change the default username and password to something else.

-SN

OK that problem is solved.Thanx alot for that mate.

but I'm new to mysql and I want to change some of the fields of some of the users(there is no password set for root).

I just dont want to get it messed up so I ask.

mySQL rules :-D :-P

Now it's time for a MySQL tutorial, else you'll be asking for every command that you want to do.

I did a google search on "mysql tutorial" and came up with a number of tutorials

Be sure to come back and let us know if our suggestions helped!