Software >> Services >> RDBMS >> Mysql >> How to turn off pagination (pager) in mysql or mariadb


## To check if pager was set

MariaDB [(none)]> status;
--------------
mysql  Ver 15.1 Distrib 5.5.65-MariaDB, for Linux (x86_64) using readline 5.1

Connection id:          4603
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          /usr/bin/less
Using outfile:          ''
Using delimiter:        ;
Server:                 MariaDB
Server version:         5.5.65-MariaDB MariaDB Server
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 11 hours 50 min 4 sec


## output when PAGER is set

MariaDB [(none)]> show databases;





## Turn off pager

MariaDB [(none)]> nopager;
PAGER set to stdout


## Output when PAGER is off

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| horde              |
| mysql              |
| opencartdb         |
| performance_schema |
| savsoft4db         |
| savsoft5db         |
| savsoft6db         |
| sgwdb              |
| sphiderdb          |
| wpdevdb            |
| wphfpdb            |
| wpmfbdb            |
| wpwpdcdb           |
| wpybsdb            |
| wpybsdevdb         |
+--------------------+
16 rows in set (0.00 sec)


## Re-enable pager

MariaDB [(none)]> pager;
PAGER set to '/usr/bin/less'