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?

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.

It looks like one should come with your MySQL install according to the MySQL webpage. Is this not what you're looking for? — cryptic_star
– cryptic_star, Commented Jul 14, 2010 at 13:23
Yes, but how can I download the client only? I don't want the whole database engine on my PC, i only need a command line client to connect to database on the other box. — PawelRoman
– PawelRoman, Commented Jul 14, 2010 at 13:34
If you have the database already installed, you must have mysql.exe already. — Buhake Sindi
– Buhake Sindi, Commented Jul 14, 2010 at 13:36
Ah. In that case, I would recommend downloading the zip, getting the client, and then dumping the rest. :) — cryptic_star
– cryptic_star, Commented Jul 14, 2010 at 13:38
This question may be better suited to superuser.com as it isn't a programming question (but rather a "how do I install..." one) — Rowland Shaw
– Rowland Shaw, Commented Jul 14, 2010 at 14:17

Sylvain · Accepted Answer · 2012-03-20 15:56:51Z

70

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.

answered Mar 20, 2012 at 15:56

Sylvain

1,5781 gold badge15 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Gabriel Chung Over a year ago

sql.exe and sql.pdb are the files you need.

vijrox Over a year ago

Once I've downloaded it, how do I install just the client?

Cléssio Mendes Over a year ago

You don't need any special install procedure. Just run sql.exe from your command line (check your environment path if it doesn't run at first)

Adam Over a year ago

MySQL now only shows the .msi downloads by default - good to have that URL you provided to the zips!

stefanbschneider Over a year ago

Add the bin folder to your PATH and then access the MySQL shell with mysqlsh --version for example.

|

Buhake Sindi · Accepted Answer · 2010-07-14 13:25:41Z

30

mysql.exe can do just that....

To connect,

mysql -u root -p (press enter)

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

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

answered Jul 14, 2010 at 13:25

Buhake Sindi

89.5k30 gold badges176 silver badges234 bronze badges

3 Comments

DS. Over a year ago

This answer assumes the MySQL package is already installed, and the question is now to get the "mysql" executable without installing the whole MySQL package.

Buhake Sindi Over a year ago

@DS, I answered this post before the EDIT.

Sergey Bogdanov Over a year ago

By the way, you can execute mysql commands on the fly with -e param like: mysql.exe -u root -e "select 'this is mysql batch script';"

spicecat · Accepted Answer · 2012-11-01 21:23:52Z

15

You can choose only install the client during server install. The website only offers to let you download the full installer (grab whatever version you want from http://www.mysql.com/downloads/mysql/).

In the install wizard, when prompted for installation type (typical, minimal, custom), choose 'Custom'. On the next screen, select to NOT install the server, and proceed with the rest of the install as normal.

When you're done, you should see just the relevant client programs (mysql, mysqldump, etc) in C:\Program Files\MySQL..\bin

answered Nov 1, 2012 at 21:23

spicecat

1591 silver badge3 bronze badges

1 Comment

Jorge Orpinel Pérez Over a year ago

Actually at least now there's a lightweight installer download (net installer) of under 19MB

dams50 · Accepted Answer · 2014-09-02 10:13:33Z

11

You can also download MySql workbench (31Mo) which includes mysql.exe and mysqldump.exe.

I successfully tested this when i had to run Perl scripts using DBD:MySql module to run SQL statements against a distant MySql db.

answered Sep 2, 2014 at 10:13

dams50

1111 silver badge2 bronze badges

Comments

basavaraj_S · Accepted Answer · 2017-05-18 06:11:37Z

10

Its pretty simple. I saved the mysql community server in my D:\ drive. Hence this is how i did it.

Goto D:\mysql-5.7.18-winx64\bin and in the address bar type cmd and press enter, so command prompt will open. Now if you're using it for the first time type as mysql -u root -ppress enter. Then it will ask for password, again press enter. Thats it you are connected to the mysql server.

Before this make sure wamp or xampp any of the local server is running because i couldn't able to connect to mysql wihthout xampp running.

Happy Coding.

answered May 18, 2017 at 6:11

basavaraj_S

1,4232 gold badges14 silver badges20 bronze badges

Comments

dialogik · Accepted Answer · 2015-01-09 13:05:19Z

7

You can access mySQL in command line just by typing:

C:\www\mysql\bin> mysql -u root -p

After which you can type sql commands normally such as:

mysql> SHOW DATABASES;

Here, I am assuming you mySQL installation directory is C:\www\mysql.

edited Jan 9, 2015 at 13:05

dialogik

9,59218 gold badges79 silver badges122 bronze badges

answered Jul 14, 2010 at 13:25

user353283

2 Comments

DS. Over a year ago

This answer assumes the MySQL package is already installed, and the question is now to get the "mysql" executable without installing the whole MySQL package.

user353283 Over a year ago

I see that we have misunderstood you. Perhaps some sort of jdbc compliant client like squirrel-sql or try isolating the mysql client for the zip download.

Peter DeGregorio · Accepted Answer · 2011-10-16 11:56:49Z

2

I have similar requirement where I need a MySQL client but not server (running in a virtual machine and don't want any additional overhead) and for me the easiest thing was to install MySQL community server taking typical installation options but NOT configure the server, so it never starts, never runs. Added C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin to system path environment variable and I'm able to use the MySQL command line client mssql.exe and mysqladmin.exe programs.

answered Oct 16, 2011 at 11:56

Peter DeGregorio

211 bronze badge

Comments

SnapShot · Accepted Answer · 2013-12-03 21:52:54Z

If you are looking for tools like the the mysql and mysqldump command line client for Windows for versions around mysql Ver 14.14 Distrib 5.6.13, for Win32 (x86) it seems to be in HOMEDRIVE:\Program Files (x86)\MySQL\MySQL Workbench version

This directory is also not placed in the path by default so you will need to add it to your PATH environment variable before you can easily run it from the command prompt.

Also, there is a mysql utilities console but it does not work for my needs. Below is a list of the capabilities on the mysql utilities console in case it works for you:

Utility           Description
----------------  ---------------------------------------------------------
mysqlauditadmin   audit log maintenance utility
mysqlauditgrep    audit log search utility
mysqldbcompare    compare databases for consistency
mysqldbcopy       copy databases from one server to another
mysqldbexport     export metadata and data from databases
mysqldbimport     import metadata and data from files
mysqldiff         compare object definitions among objects where the
                  difference is how db1.obj1 differs from db2.obj2
mysqldiskusage    show disk usage for databases
mysqlfailover     automatic replication health monitoring and failover
mysqlfrm          show CREATE TABLE from .frm files
mysqlindexcheck   check for duplicate or redundant indexes
mysqlmetagrep     search metadata
mysqlprocgrep     search process information
mysqlreplicate    establish replication with a master
mysqlrpladmin     administration utility for MySQL replication
mysqlrplcheck     check replication
mysqlrplshow      show slaves attached to a master
mysqlserverclone  start another instance of a running server
mysqlserverinfo   show server information
mysqluserclone    clone a MySQL user account to one or more new users

Naktibalda · Accepted Answer · 2010-07-14 13:23:00Z

0

mysql.exe is included in mysql package. You don't have to install anything additionally.

answered Jul 14, 2010 at 13:23

Naktibalda

14.2k5 gold badges37 silver badges53 bronze badges

1 Comment

PawelRoman Over a year ago

I don't want to instal the whole mysql database, I only need a client!

Shanmuga · Accepted Answer · 2015-02-04 14:18:45Z

0

download the mysql-5.0.23-win32.zip (this is the smallest possible one) from archived versions in mysql.com website

cut and paste the installation in c drive as mysql folder

then install then follow instructions as per this page: https://cyleft.wordpress.com/2008/07/20/fixing-mysql-service-could-not-start-1067-errors/

answered Feb 4, 2015 at 14:18

Shanmuga

1

Comments

AgileBrett · Accepted Answer · 2015-10-15 14:47:23Z

0

For Windows users: 1.Install the full version of MYSQL 2.On the Windows 10 start button click on search and type in MySQL 3. Select the MYSQL Command Line Client 5.5 (I am using version 5.5) 4. go ahead and run your sql queries/ 5. to exit type \q or quit

answered Oct 15, 2015 at 14:47

AgileBrett

1

Collectives™ on Stack Overflow

MySQL command line client for Windows

11 Answers 11

6 Comments

3 Comments

1 Comment

Comments

Comments

2 Comments

Comments

Comments

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

11 Answers 11

6 Comments

3 Comments

1 Comment

Comments

Comments

2 Comments

Comments

Comments

1 Comment

Comments

Comments

Linked

Related