Category : MySQL

mytop

October 5th, 2014 by usage | 0

Mytop is one of my classic open source and free console-based (non-gui) monitoring tool for MySQL database was written by Jereme Zawodny using Per. You’ll be asked to enter a password   related: http://www.tecmint.com/mytop-mysql-database-monitoring-in-rhel-centos-fedora/

ps

August 19th, 2010 by usage | 0

ps – reports a snapshot of the current processes. ps displays information about a selection of the active processes. If you want a repetitive update of the selection and the displayed information, use top(1) instead. This version of ps accepts several kinds of options: 1   UNIX options, which may be grouped and must be preceded […]

7z

August 11th, 2010 by usage | 0

How to compress a folder recursively with 7zip. Exclude all .log, .gz and .tar files Example if it takes a lot of resources you may want to do this (as root of course) (thanks George Valkov) 7zip Help Related http://dotnetperls.com/7-zip-examples http://www.howtoadvice.com/7zipHelper

MySQL Grant

April 11th, 2009 by usage | 0

Create a user with limited permissions GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, CREATE ROUTINE, ALTER ROUTINE,CREATE TEMPORARY TABLES,DROP,INDEX, LOCK TABLES ON yourdb.* TO usr@localhost IDENTIFIED BY “pwd” if you want to create a user that has access to databases that start with a certain prefix. GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, […]