[MariaDB]: How to disable load data and enable skip_show_database
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] sed “s/#skip-show-database/skip-show-database/g” my.cnf | grep skip
skip-show-database
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ]
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] sed -i “s/#skip-show-database/skip-show-database/g” my.cnf
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ]
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] grep ‘skip’ my.cnf
skip-show-database
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ]
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] service rh-mariadb101-mariadb restart
Stopping rh-mariadb101-mariadb: [ OK ]
Starting rh-mariadb101-mariadb: [ OK ]
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ]
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ]
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ]
[ root @ dbversity : ~ ] mysql -u root -p -h localhost –ssl
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.1.13-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]>
MariaDB [(none)]> show global variables like “%skip_show%”;
+——————–+——-+
| Variable_name | Value |
+——————–+——-+
| skip_show_database | ON |
+——————–+——-+
1 row in set (0.00 sec)
MariaDB [(none)]>
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] grep ‘local-infile’ my.cnf
local-infile=0
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ]
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] mysql -u root -p’dbversity’ -h localhost –ssl
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.1.13-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]> show global variables like “%local%”;
+—————+——-+
| Variable_name | Value |
+—————+——-+
| local_infile | OFF |
+—————+——-+
1 row in set (0.00 sec)
MariaDB [(none)]>