Useful Commands

Insert using commands to be copied and pastred as needed.

Include description.

Git Repository

Network Status

  • lsof -i - Lists what processes are using what ports (Linix)
  • sudo lsof -Pnl +M -i4
  • netstat -lnput List ports in use (Linux)
MySQL

Adding Users:

GRANT privileges 
ON databasename.tablename
TO username
Identified by 'password';

example:

GRANT SELECT, INSERT  [I]//or GRANT ALL to grant all privileges[/I]
ON DB1.*
TO AMEZIS 
IDENTIFIED BY 'PIZZA';

GRANT ALL PRIVILEGES on skontest.* to 'skon'@'localhost' IDENTIFIED BY 'password' with grant option;

mysql> update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='tom';

-- JimSkon - 2011-06-21

Topic revision: r5 - 2011-07-06 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback