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 ] […
how to disable mysql_history in MariaDB/MySQL
MariaDB/MySQL stores the commands typed in the mysql> prompt in the ~/.mysql_history file. [ root @ dbversity : ~ ] ll -lhtr .mysql_history -rw——- 1 root root 19K Jun 15 06:12 .mysql_history [ root @ dbversity : ~ ] …
Don’t miss the 2nd annual MongoDB Community Open House
Maybe people from Percona at this event will be able to tell us why they are more focused on MongoDB instead of MariaDB… View in browser Mark your calendar! We’re excited to announce the 2nd annual…
TokuDB with MariaDB ?
https://mariadb.com/kb/en/mariadb/tokudb/ https://mariadb.com/kb/en/mariadb/enabling-tokudb/ https://mariadb.com/kb/en/mariadb/tokudb-differences/ http://www.chriscalender.com/enabling-tokudb-in-mariadb-is-a-breeze/ https://mariadb.com/kb/en/mariadb/tokudb-system-variables/
MariaDB Enterprise Installation
Installing MariaDB Enterprise Windows Packages 1. Login to http://mariadb.com and click on the My Portal link then on Downloads 2. In the Enterprise Products section, use the menus to select the version of MariaDB Enterprise you are interested in and…
Introducing MariaDB ColumnStore
MariaDB Introducing MariaDB ColumnStore! ribbon banner ribbon left shadow Hello DBversity, Today marks a significant milestone for the MariaDB community. We are announcing the upcoming release of our big data analytics engine, MariaDB ColumnStore. With this release, MariaDB will offer…
Guide To Budget Friendly Data Mining
Unlike traditional application programming, where API functions are changing every day, database programming basically remains the same. The first version of Microsoft Visual Studio .NET was released in February 2002, with a new version released about every two years, not…