Debian Reset MySQL Root Password

Only for mysql server installed by ‘apt-get‘.

Under System root and localhost only.

You can find password for ‘debian-sys-maint‘, you can update root password by logging in as this user.

If you have replication, you may need to update all slaves manually.

Debian Reset MySQL Root Password by @sskaje: https://sskaje.me/2015/06/debian-reset-mysql-root-password/

MySQL/Hive/Presto/Impala Transposition

Rows to Columns

Rows to Comma Separated String

MySQL

Use GROUP_CONCAT(). This function also works in Infobright.
Continue reading “MySQL/Hive/Presto/Impala Transposition” »

MySQL/Hive/Presto/Impala Transposition by @sskaje: https://sskaje.me/2014/02/mysql-hive-presto-impala-transposition/

Incoming search terms: