MYSQL won't install properly, even though PHP and Apache are already working
 

Hellow, I am a newcomer to mysql and have installed my php and apache perfectly fine, and followed all directions in a book "PHP Programming with MySQL by Don Gosselin.". However, when I try to do this "mysqladmin version" to test to see if it works, I get this error:
The particular book I am following is for version 4.2, however I am using version 5? Is there extra stuff I need to do to configure it because of that?

I am just a beginner to this, not to all programming but to this, and I have no idea what I could be doing wrong. Can someone please try to tell me potential causes to my troubles? Any setting or configuration, any relevant knowledge, could help me. I truly am using this for my first time and have no clue where to start solving this problem.

How are you trying to load mysqladmin? It should be along these lines:


Where your username is usually "root", and the command is whatever you want to do.

Yes, you should read the mysql administration guide.. I don't think you are having problems installing mySQL, I think you just need to configure your administration and user account.

Hmm.. are you running it on windows or linux? just wonder, i have v5.02 installed and i run:

mysql -u root -p

and it request a password for me to login to the server via a command prompt.

if you are running windows, and want to know if it is setup properly, try the GUI admin tool Mysql Administrator (it is produced by the mysql developers afaik you can get it from their site) and see if that can connect.

I am running it on Windows XP Home Edition.

Thanks for the advice, especially the person who advised me to "read the guide" which I didn't know exists. I'll try it out.

Well, so long as it is on windows.. this should help you out:
http://www.tanguay.info/wamp/installPhp5.php5?step=1

great resource, i found it ages ago when i first set everything up.