Apache Friends Support Forum

I want to learn how to work with databases via the command window. I am using the Xampp package and Apache & Mysql are running all the time.

Could and would someone tell me what it is I am not doing correctly? I tried accessing databases from \mysql and \mysql\bin. Following is from my cmd.exe window:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\user>cd c:\program files\xampp\mysql\

C:\Program Files\xampp\mysql>cd c:\program files\xampp\mysql\bin

C:\Program Files\xampp\mysql\bin>show databases;
'show' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\xampp\mysql\bin>cd c:\program files\xampp\mysql\

C:\Program Files\xampp\mysql>show databases;
'show' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\xampp\mysql>

Before loading Xampp I was able to access databases. Have I forgotten something or is Xampp set up different? What? I would greatly appreciate instruction.

Thanks.
Joan

JoanW

In all the entries you tried, you have only changed to a directory, but has not started the mySQL command line client.

Refer to your previous post on this subject:
http://community.apachefriends.org/f/viewtopi ... ght=#60606

Okay. Color me chagrined. I saved that answer (in November) in Notepad to have on hand should I forget... a lot of good saving it did since I forgot I saved it. And I reckon it is apparent that once I learned the first time, I had not been back.

I bet I remember now!!

Thank you! Again!!!
Joan

Joan,

"Color me chagrined."

Maybe, but I wanted to thank you and cj_nza. You helped me find the answer.


Thanks

Well, good!!!

Joan