TWiki> Main Web>UsefulCommands (revision 3)EditAttach

Useful Commands

Insert using commands to be copied and pastred as needed.

Include description.

Network Status

  • lsof -i - Lists what processes are using what ports (Linix)
  • netstat -lnput List ports in use (Linux)

Adding Users:

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


GRANT SELECT, INSERT  [I]//or GRANT ALL to grant all privileges[/I]
ON DB1.*

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

Edit | Attach | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r3 - 2011-06-22 - 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