Difference: UsefulCommands (1 vs. 5)

Revision 52011-07-06 - JimSkon

Line: 1 to 1
 
META TOPICPARENT name="WebHome"

Useful Commands

Line: 10 to 10
 

Network Status

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

Revision 42011-06-29 - JimSkon

Line: 1 to 1
 
META TOPICPARENT name="WebHome"

Useful Commands

Insert using commands to be copied and pastred as needed.

Include description.

Changed:
<
<
>
>

Git Repository

 

Network Status

  • lsof -i - Lists what processes are using what ports (Linix)
  • netstat -lnput List ports in use (Linux)
Line: 28 to 30
  mysql> update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='tom';
Deleted:
<
<
 -- JimSkon - 2011-06-21

Revision 32011-06-22 - JimSkon

Line: 1 to 1
 
META TOPICPARENT name="WebHome"

Useful Commands

Line: 24 to 24
 TO AMEZIS IDENTIFIED BY 'PIZZA';
Added:
>
>
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 \ No newline at end of file

Revision 22011-06-21 - JimSkon

Line: 1 to 1
 
META TOPICPARENT name="WebHome"

Useful Commands

Line: 9 to 9
 

Network Status

  • lsof -i - Lists what processes are using what ports (Linix)
  • netstat -lnput List ports in use (Linux)
Added:
>
>
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';
 -- JimSkon - 2011-06-21

Revision 12011-06-21 - JimSkon

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="WebHome"

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)
-- JimSkon - 2011-06-21
 
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