MySQL command line client for Windows!

Question

Is there any nice command-line MySQL client for windows? I mean a single exe that allows connecting and running a sample query. I've googled and only could find big graphical environments like toad or MySQL workbench. I need only a simple command-line tool, where can I download sth like this?

Answer 1

To write command line for windows_____

mysql.exe can do just that...

To connect,

MySQL -u root -p (press enter)

It should prompt you to enter the root password (u = username, p = password)

Then you can use SQL database commands to do pretty much anything...