How To ?

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 w

Q: what are different version of c# and their framework support  ? Ans : c#1.0 ,1.2,2.0,3.0,4.0,5. and 6.0 are different version of c# .  Frame work  - dot net version  .Net Framework 1.0  =  c#1.0  visual studio 2002  .Net Framework 1.1   = c#1.2 Visual studio 2003  .Net Framework 2.0  =  c# 2.0    = visual studio 2005  .Net Framework 2.0 ,3.0, 3.5   =  c#3.0 =  visual studio 2008 , visual studio 2010  .Net Framework 4.0  = c#4.0   visual studio 2010  .Net Framework 4.5  = c#5.0  = visual studio 2012, 2013  .Net Framework 4.6  = c#6.0  = visual studio 2015 Q : what are method in c# ? Ans : Method or function(will have return type) will be used  for writing a programme in more manageable way , syntax for methods  :  [attribute]   access-modifiers  return type  method name(parameter)    {       //body    } Method can be declare in two type  1 : Instance  2 : Static , for declaring  a method as static use keyword static in method e.g. public static void hello()

Installing MySql 5.6 in  My Linux Server RHEL6 , but problem was that there was no internet connectivity in server . so for installing  MySql need to download  three .rpm file , that you can download from any other   another internet connected pc  and put those rpm file in RHEL6 Machine . MySQL-server-5.6.16-1.el6.X86_64.rpm MySQL-client-5.6.16.el6.x84_64.rpm MySQL-embeded-5.6.16-1.el6.x86_64.rpm i have installed all three rpm by using command : rpm -ivh server   then  rpm -ivh embeded  then rpm - client . but when i started service ,service shows ,there is no mysql service available in ,so i tried to uninstall by using command rpm -ev .rpm file .......................................... but  it is showing rpm file is not installed . after searching from multiple troubleshoot ,i have found a solution to uninstall rpm file by using below mentioned command  : rpm -ev --nonscripts   make sure , remove .rpm extension from the file name for uninstalling the file .. after u

Hello  Friends ,In this topic  we will discuss about  administrator task  and few basic concept , how Resolve the basic problems in My Sql  . First You should know about variables or parameter  that are used by the MySql Application  because as load will be increase in database ,then you should know which parameter is going to be  change for smooth performance of mysql .. Q : how to check variable list in Mysql ? Ans :  Mysqladmin variables or   show variables  command in msysql cli . can be used to get the variable list  of msql . For example  Few Variable List :  have_innodb  for  checking inndob enable or not  have_isam    for indicates whether ISAM tables are available . key_buffer_size  : sets the size of buffer used for indexes shared among thread .  log  : indicate whether logging is enable for all queries or not . Q : What are support config file  used  in MySql  for defining  setting of msyql . Ans  : my-small.cnf ,my-medium.cnf , my-large.cnf , my-heavy.cnf  .  

Q : how to optimize select statement  ? Ans  : first check with permission set up when you issue with grant statement enables MySQL to reduce permission checking overhead when clients execute statement. example  : table or column level privileges , server need to check table_priv and columns_priv tables. if your problem with some specific MySQL expression or function , use BENCHMARK() function from mysql client  to perform timing test   . Syntax  : select benchmark(100000,1=1) ; result executed in some second . so bench mark is a great tool to find out any problem with query . Q : Difference between describe and explain  in MySQL ans : Describe keyword is used for table structure while explain is used to obtain query execution                plan .explain works on select ,delete ,insert ,update or replace. Q : how to analyze table ? Ans :   analyze table table_name ; Q : How to Optimize Table . Ans : optimize table command is equal to mysqlcheck -with --optimize opti