SSH terminal window - truncated output?

Off-Topic
1

So we use SecureCRT for our SSH terminal (similar to putty etc)

When I do a show from the console (like "show grants for role ‘ROLE_NAME’ ) the output is truncated.

I’m curious if anyone has had this issue and knows how to configure the terminal settings to get it to properly show all the text?

My terminal window for SecureCRT is setup as:

Terminal: ANSI
Logical Rows: 65
Logical Columns: 200
On resize: “Scale the Font” (versus synchronize view to size or retain size & font)

I did figure out if I turn on “Line Wrap” in the SSH terminal settings it will wrap the output - which is workable but not ideal

2

That sounds like a terminal program issue, not a database issue. You could try

show grants \G

from the singlestore (mysql) client. But since there is only one column of output I doubt that will help. Did you google for help on SecureCRT truncation?

Things work fine from the mac terminal window program using a mysql client, if you have access to that.