Menu
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?
EDIT: I don't want to install the whole MySQL package on my PC. I know it's inside the mysql package but how do I download only this cmd line client. Because i don't need anything else.
212
Launch the MySQL Command-Line Client. To launch the client, enter the following command in a Command Prompt window: mysql -u root -p . The -p option is needed only if a root password is defined for MySQL. Enter the password when prompted.
To install MySQL Shell on Microsoft Windows using the MSI Installer, do the following: Download the Windows (x86, 64-bit), MSI Installer package from http://dev.mysql.com/downloads/shell/. When prompted, click Run. Follow the steps in the Setup Wizard.
The mysql command-line client is typically located in the bin directory of the MySQL's installation folder. If the mysql program is already in the PATH , you can simply invoke it using mysql command. -u root means that you connect to the MySQL Server using the user account root .
When you go to the MySQL download page, choose the platform "Microsoft Windows". Then download the "Windows (x86, xx-bit), ZIP Archive" (be sure to select the one with size over 140M.
The binaries will be in the "bin" folder.
I understand that this is not just the client binaries, but at least you don't have to install and setup the entire server.
157
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
