"Kevin Yank's Database driven website..." MySQL connection issue

I’m reading the 4th edition of Database driven…with MySQL and PHP. I’ve had most of my issues with the other components sorted with info from this site, however, after reaching

Post-Installation Set-up Tasks

trying to check MySQL status query mysqladmin -u root status in the command prompt I get the following message:

mysqladmin: connect to server at ‘localhost’ failed
error: 'Access denied for user ‘root’@‘localhost’ (using password: NO)

I’ve installed the MySQL community server 5.5.14 using the Windows (x86, 32-bit), MSI Installer and mysqld.exe is running in processes. If anyone could shed some light on the matter, it would be great.

I’ve been bogged down on just installing the components for the last 2 days. Since the book says it’s better to do it separately, i.e. learn more i’m trying to stick to it, but i’d really just get started on the coding and other aspects of the languages. :confused:

Possibly useful for you:
MySQL :: MySQL 5.0 Reference Manual :: C.5.4.1 How to Reset the Root Password

I tried that and the option to set password from the book. However my MySQL installation dir only has one .ini and two .bak files and nothing else. Maybe I have downloaded the wrong version?

I don’t understand your response. You should have only one .ini file (my.ini in Windows, my.cnf in Linux). How is this related to changing your password?

Sorry I meant that the directory MySQL was installed to had only ‘my.ini’ and two .bak files and there were no bin directories or anything else. I’ve reinstalled it and everything seems to be in order and i’ve just successfully reset and connected to MySQL. Thank you so much for your help.

Cheers.