Find knowledge base article(s) by searching for keywords in the title e.g. type linux in the search box below
Find knowledge base article(s) by browsing the subject categories of articles
Technology quick references, cheatsheets, user manuals etc.
Shop Online through ShopifyLite
Tutorials on various IT applications.
Search Title    (UL:0 |SS:f)

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'


 





[ © 2008-2021 myfaqbase.com - A property of WPDC Consulting ]