How to clear MySQL screen console in Windows?

Question

The title is my question. I googled and try something like

mysql> !\ clear
mysql> !\ cls
mysql> system cls
mysql> system clear 

blah blah ...

but none of them works.

Anyone show me how to clear screen, just like cls command in Windows?

Hi friend can you try this [link] (https://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html), so that this might help you — Smart003, Jul 24 '15 at 07:31
For Windows 11 on PowerShell running MySQL 8, `system cls` is work Fine. — Ibram Reda, Jul 27 '23 at 12:08

score 52 · Answer 1 · edited Dec 22 '21 at 06:47

52

I don't think Any of the commands will work.

In Linux Ctrl+L will do the job. In Windows there is no equivalent. You can only exit MySQL console by executing quit, execute cls and then re-enter MySQL console.

edited Dec 22 '21 at 06:47

informatik01

16,038
10
74
104

answered Jan 10 '12 at 17:48

score 49 · Answer 2 · edited Dec 30 '21 at 22:36

49

You are typing the command wrong. It is \ before ! and not after.

The command Ctrl+L will not work for Windows. To clear MySQL console screen, type the following command:

mysql> \! cls

Explanation:

\! is used to execute system shell commands
cls is a command to clear the Windows command prompt screen

This will do the job for Windows.

Similarly if you are on Linux, you will type Ctrl+L or the following:

mysql> \! clear

Source: https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html

edited Dec 30 '21 at 22:36

Itchydon

2,572
6
19
33

answered Oct 24 '20 at 05:29

yogeshwar

591
4
5

5

Works with "\! cls" in Windows 10, thank you! – Dylan Jan 06 '21 at 00:35
2

this answer is working fine in Windows 10. Commenting just for helping purpose. – Ankit Mishra Jul 25 '21 at 07:36
also works on ubuntu - if anyone is interested – AthulMuralidhar Mar 27 '23 at 08:47

score 40 · Accepted Answer · answered Jan 10 '12 at 17:49

40

This is not possible on Windows.

There is an open bug for this issue: Bug #58680: Windows Clear Screen Command

answered Jan 10 '12 at 17:49

dogbane

266,786
75
396
414

10

In linux Ctrl-L will worked fine but for window there is no any option. – Sadikhasan Apr 24 '14 at 13:00
6

They are probably in no rush to fix it, since Linux users usually look down their noses at Windows users, whom they perceive as second class citizens. – David A. Gray Aug 01 '17 at 18:42
This is not a fix but pressing Enter until I get the cursor down eases my mind. – LizardKingLK Mar 17 '22 at 06:06

score 36 · Answer 4 · edited Jan 22 '18 at 20:59

36

mysql> 
root@xion:~# mysql -uroot -ppassword;
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 33291
Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \! clear

edited Jan 22 '18 at 20:59

Stewart

17,616
8
52
80

answered Jun 15 '13 at 11:05

Milind Morey

2,100
19
15

score 10 · Answer 5 · edited Jun 26 '17 at 04:25

10

Just scroll down with your mouse

In Linux Ctrl+L will do but if your scroll up you will see the old commands

So I would suggest scrolling down in windows using mouse

edited Jun 26 '17 at 04:25

The Hungry Dictator

3,444
5
37
53

answered Nov 03 '15 at 01:44

jafaritaqi

578
7
14

It works also for windows PowerShell – Youcef LAIDANI Oct 19 '21 at 08:24

score 9 · Answer 6 · edited Aug 30 '17 at 08:27

9

On linux : you can use ctrl + L or type command system clear.

edited Aug 30 '17 at 08:27

Milan Chheda

8,159
3
20
35

answered Aug 30 '17 at 07:20

Niket Thada

103
1
5

score 5 · Answer 7 · answered Jan 25 '15 at 11:32

5

although there is bug for clearing the screen in MySQL, I have found one tactic trick whatever you want to say...

you can easily clear the screen using this...

just press ( ctrl + down arrow ) until you reach to top... happy codding...

answered Jan 25 '15 at 11:32

kunal doidya

61
1
1

score 4 · Answer 8 · edited Nov 29 '13 at 01:55

This is what I did to get around this bug. The windows console (cmd) is just not worth using for anything other than some simple commands. So the following is what I did.

Installed Cygwin (Go here) It is pretty straight forward to install. You can watch this video. It explains very easily how to install cygwin. Make sure when you select the packages that you want to install includes Mintt (it is basically a better shell or cmd) and mysql client package.

Once you are done installing it, you should add the bin folder from cygwin in your PATH Environmental Variables(The above video explains that as well)

Now You will have an icon on the desktop for cygwin. Open it up and login to mysql using the normal commands. You will need to put the ip of the mysql server in the command to make it work. I use the following logging in MySQL which was installed through wamp

mysql -u root -p -h 127.0.0.1

You can add more arguments in there if you want. Once you get in mysql just press ctrl + L and you will clear the screen.

score 4 · Answer 9 · edited Jun 18 '19 at 07:12

4

I had the same issue, and CTRL+L worked for me on Windows 10.

edited Jun 18 '19 at 07:12

Laurenz Albe

209,280
17
206
263

answered Jun 18 '19 at 06:52

dzoneuser

63
1
7

1

This works for me (MySQL console in Cmder on Windows 10) – schellingerht Oct 17 '19 at 11:31
you can Use the command system cls and this will clear the MYSQL Command Line window in Windows – Rohit Chaurasiya Dec 03 '20 at 06:46

score 4 · Answer 10 · answered Apr 08 '20 at 15:17

4

mysql console can cleared out on windows by using shortcut key

CTRL + L

answered Apr 08 '20 at 15:17

CHAITTNYA SHINDE

41
1

score 2 · Answer 11 · answered Jan 25 '21 at 02:15

2

just type \system cls

took me a couple hours to get it jejej

answered Jan 25 '21 at 02:15

Melolailo

59
6

Piyush Pranjal · Answer 12 · 2022-07-24T13:43:57.187

Yes, you can clear the screen no matter whether you're using Command line Client or any Linux Terminal

We're using cls in cmd and clear in terminal to clear the screen.
Command line client and Terminal accepts the same command with either system or \! flag.
Both commands listed below are valid!

Command Line Client:
system cls
\! cls

For Terminal:
system clear;
\! clear;

Other commands can be found here for MySql Command Line Client
Change the version number form the top right corner on the website.

score 1 · Answer 13 · answered Aug 01 '12 at 14:18

Well, if you installed MySql Server e.g. Version 5.5. which has it's folder located in:

C:\Program Files\MySQL\MySQL Server 5.5\bin

The best way would be to include it in your paths.

First run sysdm.cpl applet from run i.e. WinKey + R
Navigate to Advanced -> Environment Variables
Select PATH and Click Edit.
Scroll to the end of the text, and add ";C:\Program Files\MySQL\MySQL Server 5.5\bin" without quotes (Notice the semicolon starting the text, this should only be added if it's not already there),

Now you can just call:

start /b /wait mysql -u root -p

via command prompt.

To clear the screen now, you can just exit in mysql & call cls

Kinda trickish hack but does the job.

If you're using WAMP or other tool, it's even easier!

Open command prompt and type:

C:\wamp\mysql\bin\mysql -u root -p

Enter as normal, then whenever you want to clear screen, do:

exit or quit

And then clear using DOS:

cls

You can easily re-enter by pressing up twice to get your mysql call command

score 1 · Answer 14 · answered Sep 19 '15 at 04:20

1

you can type the following step:

mysql> exit;

C:\xampp\mysql\bin> cls

C:\xampp\mysql\bin> mysql -u root -h localhost

it's work!

answered Sep 19 '15 at 04:20

edrianhadinata

77
1
8

score 1 · Answer 15 · edited Oct 06 '15 at 01:21

1

I handle it as follows:

Right click on cmd open property's goto layout
Set screen buffer height to 9999 and ok
Now whenever you want to type a new query, just scroll with the mouse and you will get a blank screen

edited Oct 06 '15 at 01:21

spenibus

4,339
11
26
35

answered Oct 06 '15 at 01:09

Akash

11
2

score 1 · Answer 16 · answered May 29 '18 at 05:35

1

SQL> clear scr

This command clears the screen in MYSQL

answered May 29 '18 at 05:35

Deepa Madiwalar

11
1

score 1 · Answer 17 · answered May 05 '20 at 07:21

1

Unfortunately in Windows, It is not possible. The only way out is to exit and type cls and then again open mySQL

answered May 05 '20 at 07:21

Pratiik Priyadarsan

11
3

score 1 · Answer 18 · answered May 22 '20 at 00:41

1

It worked for me using this:

clear screen

answered May 22 '20 at 00:41

LFer

11
1

score 1 · Answer 19 · edited Jun 12 '20 at 02:32

1

For windows command prompt

Use

system cls

edited Jun 12 '20 at 02:32

kyun

9,710
9
31
66

answered Jun 12 '20 at 02:13

Chowdary

11
1

score 1 · Answer 20 · answered Jul 09 '20 at 10:04

1

The bug on Windows which most people are talking is probably fixed. Ctrl + L is works for clearing the screen on Windows 10 [Mysql 8]

answered Jul 09 '20 at 10:04

saonnet

110
7

score 1 · Answer 21 · answered Feb 21 '22 at 14:12

1

For windows user just type system cls;

Note don't forgot to add semicolon ; at the last.

answered Feb 21 '22 at 14:12

Neeraj Tangariya

1,159
1
17
29

score 0 · Answer 22 · answered Jan 28 '16 at 10:15

Open Properties by clicking the upper left console window icon, go to Layout tab, take note of the value set in Screen Buffer Size->Height, and change it to 1. Click OK.
You'll see a 1 row console. Open Properties again and change that value back to what it had before. Resize the console down and you'll have a clean console.

score 0 · Answer 23 · answered Jul 04 '20 at 00:19

0

Fixed in 8.0.19.

Previously, the system (!) command for the mysql command-line client worked only for Unix and Unix-like systems. It now works on Windows as well. For example, system cls or ! cls may be used to clear the screen.

answered Jul 04 '20 at 00:19

mXrio

1

Shivam Sourav Jha · Answer 24 · 2020-09-28T19:39:31.937

0

I used the command line client prompt and to clear the screen I typed:-

system cls

edited Sep 28 '20 at 19:39

answered Sep 27 '20 at 14:25

Shivam Sourav Jha

67
13

1

add a short explanation why this answer is better or how this works. it makes answers better. – Jay Sep 27 '20 at 15:58
My possible explanation would be that I tried running all others including ctrl+L but it didn't work. – Shivam Sourav Jha Sep 28 '20 at 19:41

score 0 · Answer 25 · answered Dec 03 '20 at 06:47

0

For Window 10

Use the command system cls and this will clear the MYSQL Command Line window in Windows

answered Dec 03 '20 at 06:47

Rohit Chaurasiya

446
4
8

score 0 · Answer 26 · answered Oct 21 '22 at 10:15

0

As of 26 July, 2019. This issue has been fixed.

Use can either of them with out without semicolon to clear mysql console on windows.

system cls
\! cls

Source: Bug #58680 Windows Clear Screen Command

answered Oct 21 '22 at 10:15

darknova

61
1
3

score -1 · Answer 27 · edited Sep 16 '15 at 05:04

-1

Click with contextMenu button on Mysql prompt and choose "Scroll", because I didn't find any way to clean too. =P

edited Sep 16 '15 at 05:04

uri2x

3,162
1
11
25

answered Sep 16 '15 at 03:06

lebzra

1

How to clear MySQL screen console in Windows?

27 Answers27

Command Line Client:

For Terminal:

Linked