Blog Archives

How to change to a different user in Linux

So, you want to be a different user, but don’t want to shell in again? ok, there are a couple things you could do: If you know the password su otheruser If you dont know the password, but have sudo

Posted in Linux

How to see whats running in MySQL

Short List Show Processlist; Detailed List Show full Processlist; If you like the linux TOP or HTOP try this: watch -n1 ‘echo “show processlist” | mysql -uyourusername -pyourpass | grep -v “show processlist”‘ Save it as a .file. but make

Tagged with:
Posted in Data Warehouse, ETL, Linux, MySQL, SQL

How to restart MySQL

FEDORA/REDHAT sudo /etc/init.d/mysqld restart Ubuntu sudo /etc/init.d/mysql restart WINDOWS Install Linux

Tagged with:
Posted in Linux, MySQL