[RESOLVED] I want to work in MySQL through xampp - where is MySQL?

dvarsam

Hello all!

I have installed Xampp (includes Apache, Php & MySQL) in a windows PC.
How can I access the MySQL program?

I select "Start\All Programs\Accessories\Terminal" & type "myslq -u root -p" but get Nothing!!!

How do I access my MySQL on a Windows PC?

Thanks.

TheoGB

I've only ever installed MySQL separately but it installs to C:\MySQL as standard.

The EXEs are in the 'bin' directory off that. You'll need to add them to your path statement if you want to run it from any location but bin.

The command (in the command line) should be something like:

Set path=%PATH%;c:\mysql\bin;c:\mysql

Assuming the MySQL path is right. You should probably alter your config.sys file (I think it is, there's a second one too) to make it permanent.

NogDog

You either need to change to the mysql/bin directory (something like "cd c:\program files\xampp\mysql\bin"), or else add it to your path setting.

dvarsam

NogDog wrote:
You either need to change to the mysql/bin directory (something like "cd c:\program files\xampp\mysql\bin"), or else add it to your path setting.

Thanks for your reply!
What you suggested does NOT work!
Provided Snapshot:

I tried double-clicking all icons in there & none launches the MySQL Terminal window.
Any other suggestions?

Thanks.

TheoGB

They won't work like that I don't think.

Do Start -> Run and then just put in CMD

When the Command window opens you need to put:

Set path=%PATH%;c:\program files\xampp\mysql\bin;c:\program files\xampp\mysql\

Then you can just type:
mysql -u root -p

dvarsam

TheoGB wrote:
They won't work like that I don't think.

Do Start -> Run and then just put in CMD

When the Command window opens you need to put:

Set path=%PATH%;c:\program files\xampp\mysql\bin;c:\program files\xampp\mysql\

Then you can just type:
mysql -u root -p

This is awesome man!
Crisp & Clear.
It worked great!
Thank you 😉

Weedpacket

Well, that is what NogDog suggested....

TheoGB

Weedpacket wrote:
Well, that is what NogDog suggested....

Indeed. It's also what I suggested. I just didn't know what path MySQL would go to! 😃