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:

MySQL/Hive/Presto/Impala Transposition

Rows to Columns

Rows to Comma Separated String


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

MySQL/Hive/Presto/Impala Transposition by @sskaje:

Incoming search terms: