Category: database / MariaDB / MySQL / Postgress / DB

MySQL MariaDB cheat sheet

login to mysql: su – root; list all available databases: # login & send command to mysql & logout mysql -u root -e ‘show databases’ -s –skip-column-names # or login mysql -u root -p; # enter command mysql> show databases; […]

howto postgres – multi threaded backup and restore

postgres borrows concepts from mysql (now mariadb) postgres and mariadb are borth great databases, thanks all involved. (how to setup postgres 12 on centos 8 (very very latest)) let’s dive into hit: how to postgres: hostnamectl; # tested on Virtualization: […]

how to setup basic LAMP stack GNU Linux Debian – (Apache2 php7.3 MariaDB) (how to install xdebug – step debugging php requests in eclipse pdt on debian 10 buster (LAMP web development stack)) – how to enable mariadb mysql log file creation logging (also restarts) – how to Error occurred: (1034, “Index for table ‘proc’ is corrupt; try to repair it”)

setup LAMP GNU-Linux Apache2 MariaDB PHP7.3 su – root; # become root apt update; # update system to latest apt upgrade; # database first apt install mariadb-server mariadb-client # set root pwd for database (can be root on dev test […]

gnu-linux – setup postgres 12 on CentOS 8 – terminal bash – debugging postgresql connection problems

here are the packages: # updated: 2021-01 # the guide below is probably outdated # the official current howto # tries to install postgres13 like this: # Install the repository RPM: dnf install -y # Disable the […]

Russian IT Security Updates 2020-01

now WITH SPICY COMMENTS X-D SecurityLab, [22.12.19 12:40] A Twitter user using the alias 08Tc3wBB created tfp0-an exploit that allows you to jailbreak the latest iPhone models with IOS 13.3. The functionality of the exploit has already been confirmed by […]

MySQL search replace update where sql query

yes, it is NOT the most convenient, query you could imagine. UPDATE `table_name` SET `column_name` = REPLACE(`column_name`, ‘replace_this’, ‘with_this’) WHERE `column_name` LIKE ‘%with_this%’ COLLATE utf8mb4_bin; it is what phpmyadmin generates when you go here:


docker exec -it -u postgres example-db psql; # login interactively SELECT * FROM pg_stat_activity WHERE datname = ‘example’; # check open connections to database example # (there shall be none, otherwise you can not drop the database) SELECT pg_terminate_backend ( […]

Was macht eigentlich ORACLE?

Jeder kennt Steve Jobs (now dead) – aber wer kennt schon “Larry” Ellison? 😀 Oracle hat 2010 die Firma “Sun Microsystem aufgekauft” und damit OpenSource Technologie wie Java, VirtualBox und MySQL eingekauft. Lawrence Joseph “Larry” Ellison (born August 17, 1944) […]


tested with older GNU Linux Debian7 3.2.0-4-amd64 #1 SMP Debian 3.2.46-1+deb7u1 x86_64 GNU/Linux in any case you need to stop current mysql operation: # become root su – root /etc/init.d/mysql stop; # stop mysql service # if that did not […]


MySQL – Resetting a lost MySQL root password warning this article is rather old and might be (partly) outdated! Article ID: 405 Last updated on August 31, 2012 Authored by: Rackspace Support creditz: The MySQL root password allows full […]


login to mysql to see what databases are there. mysql -u root -p mysql> show databases; +———————-+ | Database | +———————-+ | information_schema | | DatabaseXY | | DatabaseXYZ | | mysql | | phpmyadmin | +———————-+ 7 rows in […]