Tag Archives: Linux

How to reset root user password in MySQL 5.7+

Was too busy and haven’t written anything for quite a while! Anyway, here is how to reset the root user password in MySQL 5.7 and later in a nutshell! service mysql stop mkdir -p /var/run/mysqld chown mysql:mysql /var/run/mysqld mysqld_safe –skip-grant-tables … Continue reading

Posted in Linux, MySQL | Tagged , , , , | Leave a comment

Create a filesystem report with Python

In many cases, data accumulates over time, and a lot of this data is not being accessed at all, sometimes for years. Accordingly, it would be great if you could create a report that shows which data, the last access … Continue reading

Posted in Linux | Tagged , , , , | Leave a comment

Fix QT Apps scaling issue on hidpi screens on Ubuntu

On my 5k screen, all QT apps look very tiny, such as keepassxc and Virtualbox. The best solution I found was adding the following to your .profile to autoscale at a ratio of 2 (you can change it to your … Continue reading

Posted in Linux | Tagged , , , , | 2 Comments

How to kill all processes accessing a filesystem on Ubuntu

This is not really safe, ok 😀 ? Do it at your own risk lsof | grep /filesystem_name | awk ‘{print $2}’ | xargs kill -9 That’s it, Enjoy!

Posted in Linux | Tagged , , , , , , | Leave a comment

Using gzip to compress a file without overriding it

gzip < source_file > compressed_file.gz Source: https://unix.stackexchange.com/questions/46786/how-to-tell-gzip-to-keep-original-file

Posted in Linux | Tagged , , , | Leave a comment