Programming Forums > Web Development and Design > PHP

Josef_Stalin · Apr 7th, 2007, 2:01 PM

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:

Quote:

mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'ODBC'@'localhost' (using password : NO)'.

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.

Ooble · Apr 7th, 2007, 2:16 PM

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

(Toggle Plain Text)

mysqladmin -u username -p command

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

kurifu · Apr 7th, 2007, 4:15 PM

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.

tAK · Apr 7th, 2007, 7:53 PM

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.

Josef_Stalin · Apr 12th, 2007, 6:24 PM

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.

tAK · Apr 12th, 2007, 8:02 PM

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.

Apr 7th, 2007, 2:16 PM	#2
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	How are you trying to load mysqladmin? It should be along these lines: (Toggle Plain Text) mysqladmin -u username -p command mysqladmin -u username -p command Where your username is usually "root", and the command is whatever you want to do. __________________ Me :: You :: Them

Apr 7th, 2007, 4:15 PM	#3
kurifu Expert Programmer Join Date: Jul 2004 Location: Halifax, Nova Scotia (Canada) Posts: 784 Rep Power: 5	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. __________________ Clifford Matthew Roche <geek@cliffordroche.com> Web Hosting: http://www.crd-hosting.com Consulting: http://www.crdev-consulting.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 7th, 2007, 7:53 PM	#4
tAK Programmer Join Date: Mar 2007 Posts: 33 Rep Power: 0	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.

Apr 12th, 2007, 6:24 PM	#5
Josef_Stalin Programmer Join Date: Apr 2005 Posts: 77 Rep Power: 4	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.

Apr 12th, 2007, 8:02 PM	#6
tAK Programmer Join Date: Mar 2007 Posts: 33 Rep Power: 0	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.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > PHP

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