MariaDB

"lynx https://mariadb.org"
"wget http://ftp.hosteurope.de/mirror/mariadb.org/mariadb-10.0.16/source/mariadb-10.0.16.tar.gz"

"lynx https://mariadb.com/kb/en/mariadb/generic-build-instructions/"
"BUILD/autorun.sh"
"./configure --prefix=/usr/local/mariadb --enable-assembler \
--with-extra-charsets=complex  --enable-thread-safe-client  --with-big-tables \
--with-plugin-maria --with-aria-tmp-tables --with-readline \
--with-ssl --with-plugins=max-no-ndb --with-libevent \
--with-zlib-dir=bundled --enable-local-infile"
"make"
"make install"
"ls -al /usr/local/mariadb/"

Erstkonfiguration
"chown -R mysql /usr/local/mariadb/"
"cd /usr/local/mariadb/"
"scripts/mysql_install_db --user=mysql"
"/usr/local/mariadb/bin/mysqld_safe --user=mysql &"

"bin/mysqladmin -u root password 'new-password'"
oder
"/usr/local/mariadb/bin/mysql mysql -p"
"mysql> UPDATE user SET password = password('neues_password') WHERE user = 'root'; "
"mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "passwort"; "
"mysql> GRANT ALL PRIVILEGES ON *.* TO root@172.16.190.8 IDENTIFIED BY "passwort"; "
"mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.17.190.8' WITH GRANT OPTION; "
"mysql> UPDATE `mysql`.`user` SET `Grant_priv`='Y' WHERE  `Host`='172.17.190.8' AND `User`='root'; "

ggf.
"cp -frv /usr/local/mariadb/include/* /usr/include"
"cp -frv /usr/local/mariadb/lib/* /usr/lib"
"cp -frv /usr/local/mariadb/lib/* /usr/lib64"

##################################################
Administrations Tools
HeidiSQL (lynx http://www.heidisql.com/)
Database Workbench (lynx http://www.upscene.com/database_workbench/)

##################################################
MariaDB Audit Plugin (https://mariadb.com/kb/en/mariadb/about-the-mariadb-audit-plugin/)

##############################################
SQL ADMIN Commands

SHOW BINARY LOGS;

Post Revisions: