MySQL/PHP Question re: login

[wagnj1]

Hi all
I just recently installed Apache 2.0, PHP 4, and MySQL 4. I've got the Apache server with PHP running great, and I've got MySQL running good too, even created some tables with data.
I have a question about how you originally login. For some reason, when I try to login as root it says something about no password. I've tried setting the root password and it seems to work but it won't let me log in as root@localhost. Thus, when I create a MySQL connection with PHP, it won't connect, because you need to specify a username and password, and I don't appear to have any.
any help would be great.

[BlazingWolf]

If you set a password for the root user clear it away. Default for the root is nothing not that you can't have one but I just suggest you leave it blank if your just testing locally.

Go on google, and search for MySQL Front it's an application that helps you deal with your DB's without the console windown, and all the typing and stuff.

Once you get it and establish a connection on the Menu bar at the top go to Database>>New>>User and create a new user. Then use that login for when you want to test scripts, and things like that.