MariaDB: What is buzzing ?!
MARIADB NEWSLETTER October 2016 Welcome to the MariaDB newsletter, which features our latest updates, news, events and more. There’s so much going on that we can’t possibly fit it all into one newsletter, so keep an eye on mariadb.com to learn…
MariaDB “JDBC/Connector J” Connection with SSL enabled.
[root@dbversity-com rh-mariadb101]# cat /etc/opt/rh/rh-mariadb101/my.cnf # This group is read both both by the client and the server # use it for options that affect everything [client-server] #################### <– Client-Server SSL Options–> ####################################### ssl ssl-cipher = AES128+EECDH:AES128+EDH ssl-ca = /etc/opt/rh/rh-mariadb101/pki/ca.pem ssl-cert…
MariaDB ODBC Driver (Connector/ODBC) testing
root@dbversity-com ]# ll -lhtr -rw-r–r– 1 698K Oct 4 06:42 mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# tar -zxvf mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz mariadb-connector-odbc-2.0.12-ga-linux-x86_64/lib64/libmaodbc.so mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/COPYING mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/README [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# ll -lhrt -rw-r–r– 1 698K Oct 4…
Configuring MariaDB With PAM/Kerberos
Please note below directions assume the system is already setup to use AD for user logins. What is here will enable a MariaDB to leverage a system’s current setup. It will not deploy AD from scratch. As of MariaDB 5.0,…
[MariaDB]: Enforcing SSL for all connections
If we’ve configured required ssl configuration in the my.cnf and enabled ssl globally with required variables (have_ssl, have_open_ssl). Though we create users without REQUIRE SSL privilege, they will use SSL connection. [ root @ dbversity : /var/lib/mysql ] grep ‘ssl’…
RHEL’s MariaDB : how to do I add service script in Linux’s startup.
[ root @ my-host-name : ~ ] ps -ef | grep mysql root 2158 1 0 02:36 ? 00:00:00 /bin/sh /opt/rh/rh-mariadb101/root/usr/bin/mysqld_safe –datadir=/var/opt/rh/rh-mariadb101/lib/mysql –socket=/var/lib/mysql/mysql.sock –pid-file=/var/run/rh-mariadb101-mariadb/mariadb.pid –basedir=/opt/rh/rh-mariadb101/root/usr –user=mysql mysql 2332 2158 0 02:36 ? 00:00:00 /opt/rh/rh-mariadb101/root/usr/libexec/mysqld –basedir=/opt/rh/rh-mariadb101/root/usr –datadir=/var/opt/rh/rh-mariadb101/lib/mysql –plugin-dir=/opt/rh/rh-mariadb101/root/usr/lib64/mysql/plugin/ –user=mysql –log-error=/var/opt/rh/rh-mariadb101/log/mariadb/mariadb.log –pid-file=/var/run/rh-mariadb101-mariadb/mariadb.pid…
MariaDB User Management
CREATE [OR REPLACE] USER [IF NOT EXISTS] user_specification [,user_specification] … [ REQUIRE {NONE | tls_option [[AND] tls_option] …} ] [ WITH resource_option [resource_option] … ] ; user_specification: username [authentication_option] authentication_option: IDENTIFIED BY ‘authentication_string’ | IDENTIFIED BY PASSWORD ‘hash_string’…
MariaDB/MySQL Database Hardening
1) Start the server using –skip-show-database option. 2) All LOAD DATA LOCAL statements can be disabled from the server side by starting mysqld with the –local-infile=0 option. 3) Disable command history by setting MYSQL_HISTFILE to /dev/null or linking mysql_history to…
[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 ] […