SHOW GRANTS; SHOW GRANTS FOR CURRENT_USER; SHOW GRANTS FOR CURRENT_USER(); e.g. SHOW GRANTS FOR root; mysql> SHOW grants for root; +———————————————————————————-+ | Grants for root@% | +———————————————————————————-+ | GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY PASSWORD ‘*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B’ WITH GRANT OPTION | +———————————————————————————-+ 1 row in set (0.00 sec) mysql> nJoy 😉
Month: March 2013
Create a patch from git-diff
Really easy : git diff > patchfile.pch and patch -p1 < patchfile.pch nJoy 😉
Bash While Loop Example
How do I use bash while loop to repeat certain task under Linux / UNIX operating system? How do I set infinite loops using while statement? The bash while loop is a control flow statement that allows code or commands to be executed repeatedly based on a given condition. For example, run echo command 5…
Close ssh and leave a job running
Using the Job Control of bash to send the process into the background: ctrl+z to stop (pause) the program and get back to the shell bg to run it in the background disown -h so that the process isn’t killed when the terminal closes nJoy! 😉
When a MySQL table was last updated?
Simply do this: SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = ‘dbname’ AND TABLE_NAME = ‘tabname’ nJoy 😉
Set machine to a timezone
Simple and easy : ln -sf /usr/share/zoneinfo/UTC /etc/localtime nJoy 😉
Install Google Chromium on Backtrack 5 R3
Google Chrome is an alternative web browser beside Mozilla Firefox. It’s free and open source. But the problem Google Chrome on Backtrack 5 is Google Chrome can’t run in root mode. We know that Backtrack run the root mode by default. If you run the Google Chrome it won’t work. So if you want to…