Some Basic Linux Command .

-
Q : How to add group then user in linux . ?
Ans :
1: add group by using command groupadd
2: add a user into the group by   command  useradd  -G   . for adding a user in multiple group  just seperate user by  useradd -G,,  
3:  now add password to  user by command passwd
4:  ensure that user has been added to group use command id ,you will see information         of user id ,group id  .
5:  add a existing user to existing group 
         usermod -a -G
        -a option is used for adding user in supplementry group .

6  :  adding user  to  a derive .
        useradd  -d /directory   
          ->  this will add user to a directory .
      Now come to  password
       use command 
        password  
7: how to install .Net  in RHEL 7 .
 Ans  :  https://www.microsoft.com/net/core#redhat        


8: how to delete a user 
    userdel --remove

9: how to stop ftp(21) in linux server .

     iptables -A INPUT -p tcp --destination-port 21 -j DROP

10:  To check which port are active 
          netstat -tnlp

11: how to add  user and providing sftp permission with particular directory .
   a:   useradd -d /path
   b:   ask for password  :
       passwd
   c:  now if you want that only owner should have access of folder then  change ownership by
       mentioned command
       chown -R



Comments

Post a Comment

Popular posts from this blog

Triggers in MySQL

-
Image
Trigger MySQL: Trigger can be used in two ways with before and after with Delete ,insert and update command .Let me show you a example of before update   . I have created two table employee and employee_audit . employee table is table where my raw data will be stored and employee_audit table is table where to store data after changes or can say trigger execution . Table structure of employee and employee_audit table : CREATE TABLE   `test`.`employee` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `name` varchar(20) DEFAULT NULL,   `lstname` varchar(10) DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; CREATE TABLE   `test`.`employee_audit` ( `id` int(11) NOT NULL AUTO_INCREMENT,   `name` varchar(20) DEFAULT NULL,   `lstname` varchar(20) DEFAULT NULL,   `action` varchar(50) DEFAULT NULL,   `upd_datetime` datetime DEFAULT NULL,   `newname` varchar(20) DEFAULT NULL, ...
Read more

MySQL 8.0.2 Windows Function

-
Q : What is sql windows function  ? Ans  : a windows sql function will perform aggregation for each row in result set  , letting  each row in  the result set , leatting each row retain its identity . Example  : mysql> CREATE TABLE t(i INT); mysql> INSERT INTO t VALUES (1),(2),(3),(4); mysql> SELECT SUM(i) AS sum FROM t; +------+ | sum  | +------+ |   10 | +------+ mysql> SELECT i, SUM(i) OVER () AS sum FROM t; +------+------+ | i    | sum  | +------+------+ |    1 |   10 | |    2 |   10 | |    3 |   10 | |    4 |   10 | So  you can see only by  using over()  windows function  , sum is showing along with  each value that  has been summed . Q: what are types of windows sql function  ? Ans :  sql aggregate function can be used in ...
Read more

list in python

-
# declaring a list list_t = [ "my" , "name" , "is" , "abhishek" ] print (list_t) # accessing first list item print (list_t[ 0 ]) # accessing all item of list for x in list_t: print (x) # inserting item at position in list . list_t.insert( 0 , "hello" ) print (list_t) # extending a list lastname = [ "rathor" ] list_t.extend(lastname) print (list_t) # removing item from list list_t.pop( 0 ) print (list_t) list_t.remove( "rathor" ) print (list_t) # index of item in list print (list_t.index( 'name' )) # sorting an index list_t.sort() print (list_t) # reverse is also possible in index list_t.reverse() print (list_t) # constructing a list with constructor list2 = list (( "abhishek" , "pratap" , "singh" , "rathor" )) print (list2) # tuple and list both behave same except tuple are unchangeable and ordered collection # so inserting and removing ...
Read more