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 : ~ ] …
MySQL Master-Slave Replication on the Same Machine
MySQL replication is a process that enables data from one MySQL database server (the master) to be copied automatically to one or more MySQL database servers (the slaves). It is usually used to spread read access on multiple servers for…
Growing Growth: Perform Your Own Cohort Analysis with This Open Source Code
Cohort analysis, retention, and churn are some of the key metrics in company building. But this isn’t just another article about cohort analysis. If you’re a seasoned data scientist that already knows the importance of the topic and want to skip the introduction, you can jump to…
Data Encoding: A Guide to UTF-8 for PHP and MySQL
As a MySQL or PHP developer, once you step beyond the comfortable confines of English-only character sets, you quickly find yourself entangled in the wonderfully wacky world of UTF-8. Unicode is a widely-used computing industry standard that defines a comprehensive mapping of unique…
MySQL Fabric as a MySQL High-Availability Solutions
MySQL Fabric is a framework for managing groups of MySQL Servers and using those servers to provide services. In the current version the services provided are High Availability (built on top of MySQL Replication) and scale-out (by sharding the data)….
Create dblink from oracle to memsql
Install required RPM packages Configure ODBC gateway Setup environment variable Configure listener.ora and tnsnames.ora Configure ODBC listener Create database link and test2 Environment: Database DB Name DB Version Host Name OS Version Oracle PCRADMN…
3 Essential MySQL Interview Questions
Consider the following table definition in a MySQL database: CREATE TABLE example ( id INT NOT NULL, text1 VARCHAR(32) NOT NULL, text2 VARCHAR(32) NOT NULL DEFAULT ‘foo’ ); What will be the result of the two INSERT statements below if…