MySQL useful command

<div dir="ltr" style="text-align: left;" trbidi="on"> <img alt="" class="entry-thumb" height="525" itemprop="image" src="http://linuxgateway.in/wp-content/uploads/2015/05/MySQL-command-700x525.jpg" style="background-color: white; border: 0px; color: #4b4b4b; font-family: 'PT Sans', sans-serif; font-size: 14px; height: auto; line-height: 21px; max-width: 100%; vertical-align: middle;" title="MySQL command" width="700" /><br /> <div> <br /></div> <div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><b><span style="color: #351c75;">How to use MySQL command : Basic understanding</span></b><o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <strong style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">MySQL statements</strong></div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> </div> <ul style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin: 0px 0px 10.5px 25px; padding: 0px;"> <li style="line-height: 21px;">MySQL key words are not a case sensitive</li> <li style="line-height: 21px;">Optional items are enclosed in square brackets [ ]</li> <li style="line-height: 21px;">Don’t quote database, table, or column names</li> <li style="line-height: 21px;">Don’t quote column types or modifiers</li> <li style="line-height: 21px;">Don’t quote numerical values</li> <li style="line-height: 21px;">Quote (single or double) non-numeric values</li> <li style="line-height: 21px;">Quote file names and passwords</li> </ul> <div> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 21px;">MySQL command</span></span></div> </div> <div> <br /> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Login in to MySql database</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";"><br /></span></b></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">[root@master1 ~]# mysql -u root -p<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Create a database on the mysql server</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">create database [databasename];<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Example,<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt; margin-bottom: .0001pt; margin-bottom: 0in;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> create database kvit;<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Query OK, 1 row affected (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt; margin-bottom: .0001pt; margin-bottom: 0in;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql>  create database openpath;<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Query OK, 1 row affected (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show available  databases on mysql server</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> show databases;<br /> +————————+<br /> |   Database                 |<br /> +————————-+<br /> |   information_schema|<br /> |   kvit                          |<br /> |   mysql                      |<br /> |   openpath                |<br /> +————————-+<br /> 4 rows in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Switch to a database</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">use [db name];<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> use kvit;<br /> Database changed<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show the present use/selected  database</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> select database() from dual;<br /> +————+<br /> | database() |<br /> +————-+<br /> |   kvit          |<br /> +————-+<br /> 1 row in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">or,</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> SELECT DATABASE();<br /> +————+<br /> | DATABASE() |<br /> +—————+<br /> |   kvit             |<br /> +—————+<br /> 1 row in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show  tables inside database</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt; margin-bottom: .0001pt; margin-bottom: 0in;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> show tables;<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Empty set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Create table inside database</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">CREATE TABLE table_name<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">( column_name1 data_type(size),<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">column_name2 data_type(size),<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">……<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt; margin-bottom: .0001pt; margin-bottom: 0in;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> create table class (roll_no int, name varchar(20));<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Query OK, 0 rows affected (0.05 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">create one more table<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> create table book (name varchar(20), price int);<br /> Query OK, 0 rows affected (0.03 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show  the details of  table field formats</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">describe [table name];<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> describe class;<br /> +———+————–+——–+——+———+——–+<br /> | Field     |       Type     |   Null  |  Key | Default | Extra  |<br /> +———+————–+——–+——+———+——–+<br /> | roll_no  |  int(11)        |  YES   |         | NULL   |             |<br /> | name    |  varchar(20) |  YES   |         | NULL   |             |<br /> +———+—————+——-+——+———+———+<br /> 2 rows in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show  tables inside database</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> show tables;<br /> +—————–+<br /> | Tables_in_kvit  |<br /> +—————– +<br /> |    book              |<br /> |    class              |<br /> +——————+<br /> 2 rows in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Insert data in table</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">insert into table_name<br /> values (value1,value2,…);<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> insert into class values(01,”Gopal”);<br /> Query OK, 1 row affected (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> insert into class values(02,”Gopal”);<br /> Query OK, 1 row affected (0.00 sec)</span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show data of table </span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">select * from [table name];<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> select * from class;<br /> +———+——-+<br /> | roll_no | name |<br /> +———+——-+<br /> | 1 | Gopal |<br /> +———+——-+<br /> 1 row in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show certain row value from table</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">SELECT * FROM [table name] WHERE [field name] = “whatever”;<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> select * from class where name = ‘gopal';<br /> +———+——-+<br /> | roll_no | name |<br /> +———+——-+<br /> | 1 | Gopal |<br /> +———+——-+<br /> 1 row in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show/filter certain selected row value from table</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> select roll_no from class where name=’gopal';<br /> +———+<br /> | roll_no |<br /> +———+<br /> | 1 |<br /> +———+<br /> 1 row in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Select all record containing name(column) with “anykeyword”</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">SELECT * FROM [table name] WHERE column1 = “anykeyword” AND column2 = ‘anykeyword';<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> select * from class where name = “Gopal” and roll_no = ‘2’;<br /> +———+——-+<br /> | roll_no | name |<br /> +———+——-+<br /> | 2 | Gopal |<br /> +———+——-+<br /> 1 row in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show all records not containing the name “Gopal” and the roll_no “2” order by the roll_no field.</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql>SELECT * FROM class WHERE name != “Gopal” AND roll_no = ‘2’ order by roll_no;<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show all records starting with the letters ‘Gopal’ </span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt; margin-bottom: .0001pt; margin-bottom: 0in;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> SELECT * FROM class where name like “Gopal%”;<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">+———+——–+<br /> | roll_no | name  |<br /> +———+——–+<br /> | 1 | Gopal          |<br /> | 2 | Gopal          |<br /> +———+——–+<br /> 2 rows in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show all records starting with the letters ‘Gopal’ AND the roll_no ‘2’</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> SELECT * FROM class where name like “Gopal%” AND roll_no =”2″;<br /> +———+——–+<br /> | roll_no | name |<br /> +———+——-+<br /> | 2 | Gopal           |<br /> +———+——–+<br /> 1 rows in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show all records starting with the letters “Gopal” AND the roll_no  ‘2’ limit to records 1 through 3</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">SELECT * FROM [table name] WHERE name like “Gopal%” AND phone_number = ‘2’ limit 1,3;<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> SELECT * FROM class WHERE name like “Gopal%” AND roll_no = ‘2’ limit 1,3;<br /> +———+——-+<br /> | roll_no | name |<br /> +———+——-+<br /> | 2 | Gopal         |<br /> +———+——-+<br /> 1 row in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with “G”</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> SELECT * FROM [table name] WHERE</span><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";"> <b>name</b> </span><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">RLIKE “^g”;<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> SELECT * FROM class WHERE name RLIKE “^G”;<br /> +———+——–+<br /> | roll_no | name |<br /> +———+——–+<br /> | 1 | Gopal |<br /> | 2 | Gopal |<br /> +———+——–+<br /> 2 rows in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show unique records</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">SELECT DISTINCT [column name] FROM [table name];<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Note: insert a new value with name “gopal1″<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> SELECT DISTINCT name FROM class;<br /> +——–+<br /> | name |<br /> +——–+<br /> | Gopal |<br /> | Gopal1 |<br /> +——–+<br /> 2 rows in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Show selected records sorted in an ascending (asc) or descending (desc)</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">SELECT [col1] FROM [table name] ORDER BY [col2] DESC;<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Or, you can try if you have more column<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> SELECT roll_no FROM class ORDER BY name DESC;<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Return number of rows</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">SELECT COUNT(*) FROM [table name];<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> SELECT COUNT(*) FROM class;<br /> +———-+<br /> | COUNT(*) |<br /> +———-+<br /> | 3 |<br /> +———-+<br /> 1 row in set (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Delete MySQL database</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">drop database [database name];<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> drop database openpath;<br /> Query OK, 0 rows affected (0.03 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Delete a table from MySQL Database</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">drop table [table name];<o:p></o:p></span></div> <br /> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> drop table book;<br /> Query OK, 0 rows affected (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <br /></div> <div style="background: rgb(252, 252, 252); line-height: 17.25pt; text-align: left;"> <b><span style="color: #351c75;">Delete Statement in MySQL</span></b></div> <div style="background: rgb(252, 252, 252); line-height: 17.25pt; text-align: left;"> <b><br /></b></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">The</span><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";"> <b>Delete</b></span><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"> statement is used to delete records in a table.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Delete a row in table</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<br /> delete from table_name<br /> where some_column=some_value;<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> delete from class where name=”Gopal1″;<br /> Query OK, 1 row affected (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Delete all record from table</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Syntax,<o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">delete from table_name;<o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> delete from book;<br /> Query OK, 0 rows affected (0.00 sec)<o:p></o:p></span></i></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Or,</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> </div> <div class="MsoNormal" style="background: #FCFCFC; line-height: 17.25pt;"> <i><span style="color: grey; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">mysql> delete * from book;<o:p></o:p></span></i></div> </div> <div style="text-align: left;"> <div style="margin-bottom: 23px; position: relative; top: -9px;"> </div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> </div> <div> <div style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; font-weight: normal; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> </div> </div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> </div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> </div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> </div> </div> </div>

MySQL useful command

How to use MySQL command : Basic understanding MySQL statements MySQL key words are not a case sensitive Optional items are e...

Read more »

MySQL database server Installation, Configuration in Linux

<div dir="ltr" style="text-align: left;" trbidi="on"> <img alt="" class="entry-thumb" height="525" itemprop="image" src="http://linuxgateway.in/wp-content/uploads/2015/05/Instt-of-MySQL-SERVER-700x525.jpg" style="background-color: white; border: 0px; color: #4b4b4b; font-family: 'PT Sans', sans-serif; font-size: 14px; height: auto; line-height: 21px; max-width: 100%; vertical-align: middle;" title="Instt of MySQL SERVER" width="700" /><div> <br /></div> <div> MySQL Database Points</div> <div> <br /></div> <div> <span style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">This tutorial explain about MySQL database running on a Linux server. This tutorial will make you understand how to install and setup MySQL database server and how to use basic MySQL queries/command, which initially we use in MySQL database.</span><div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> </div> <ul style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin: 0px 0px 10.5px 25px; padding: 0px;"> <li style="line-height: 21px;">Introduction and use of Database</li> <li style="line-height: 21px;">Installation and Configuration</li> <li style="line-height: 21px;">To Login and exit from Database</li> <li style="line-height: 21px;">Data types explain</li> <li style="line-height: 21px;">Database Storage engines</li> </ul> <div> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 21px;">A brief Introduction about MySQL database</span></span></div> </div> <div> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 21px;"><br /></span></span></div> <div> <strong style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">What is Database?</strong><div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> </div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> A database is a collection of information so that it can easily be accessed, managed, and updated.</div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>What is MySQL Database?</strong></div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> MySQL is an open source database management software that helps user to store, organize, and retrieve data. MySQL offers great reliability and easy to use and maintain the record in DB. Purpose of using database is to get rid the manual task into diary or other documentary. MySQL, pronounced either “My S-Q-L” or “My Sequel,” It is based on the structure query language (<a href="http://techterms.com/definition/sql" style="color: #4db2ec; text-decoration: none !important;">SQL</a>). Standard MySQL commands, such as ADD, DROP, INSERT, and UPDATE can be used.</div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">Install and Configure MySQL Database Server in CentOS/RHEL</span></span></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <strong style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">Install MySQL package in Centos/RHEL/5 & 6 distribution</strong></div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> </div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> Install the MySQL server package through the CentOS/RHEL repository.</div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@master ~]#yum install mysql mysql-server</span></span></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <strong style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">Start Mysql Service.</strong></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@master ~]# service mysqld restart</span></span></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <strong style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">Check MySQL service status</strong></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@master ~]# service mysqld status</span></span></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <strong style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">Permanently on MySQL service on startup</strong></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@master ~]# chkconfig mysqld on </span></span></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <strong style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">Identify on which ports </strong><strong style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">MySQL work</strong></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@master ~]# netstat -tunlp | grep mysqldtcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      1657/mysqld</span></span></div> <h2 style="background-color: white; margin-bottom: 23px; position: relative; text-align: left; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">Setup MySQL root user password</span></span></h2> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <strong style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">To create root password for first time</strong><span style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">, use </span><strong style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">mysqladmin</strong><span style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;"> command at shell prompt as follows:</span></div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> </div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> [root@master ~]# mysqladmin -u root password [newpasswordhere]</div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>Example;</strong></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@master ~]# mysqladmin -u root password kvit@123</span></span></div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>Change/reset MySQL root password</strong></div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> [root@master ~]#mysqladmin -u root -p[oldpassword] password [newpass]</div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>Example;</strong></div> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@master ~]#mysqladmin -u root -pkvit@123 password kvit@321</span></span></div> <h2 style="background-color: white; margin-bottom: 23px; position: relative; text-align: left; top: -9px;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">Setup MySQL database using mysql_secure_installation command</span></span></h2> <div style="background-color: white; margin-bottom: 23px; position: relative; top: -9px;"> <span style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">Alternatively, you can run the below command </span><strong style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">mysql_secure_installation</strong><span style="color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;"> from the Linux root user, to complete the fields that make sense for your MySQL configuration.</span></div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> </div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> We recommend that you configure the following secure settings:</div> <ul style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin: 0px 0px 10.5px 25px; padding: 0px;"> <li style="line-height: 21px;">Set a password for the MySQL root user.</li> </ul> <ul style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin: 0px 0px 10.5px 25px; padding: 0px;"> <li style="line-height: 21px;">Remove MySQL anonymous users.</li> </ul> <ul style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin: 0px 0px 10.5px 25px; padding: 0px;"> <li style="line-height: 21px;">Disallow remote login for the MySQL root user.</li> </ul> <ul style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin: 0px 0px 10.5px 25px; padding: 0px;"> <li style="line-height: 21px;">The MySQL root user is allowed to connect to the database, but only from the local host.</li> </ul> <ul style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin: 0px 0px 10.5px 25px; padding: 0px;"> <li style="line-height: 21px;">Remove the test database.</li> </ul> <ul style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin: 0px 0px 10.5px 25px; padding: 0px;"> <li style="line-height: 21px;">Reload the Privileges table.</li> </ul> <div> <span style="color: #262626; font-family: PT Sans, sans-serif;"><div style="font-size: 15px; line-height: 21px;"> [root@master1 ~]# /usr/bin/mysql_secure_installation</div> <div style="font-size: 15px; line-height: 21px;"> <b>output;</b></div> <div style="font-size: 15px; line-height: 21px;"> <br /></div> <div style="font-size: 15px; line-height: 21px;"> NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL</div> <div style="font-size: 15px; line-height: 21px;"> SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!</div> <div style="font-size: 15px; line-height: 21px;"> In order to log into MySQL to secure it, we’ll need the current</div> <div style="font-size: 15px; line-height: 21px;"> password for the root user.  If you’ve just installed MySQL, and</div> <div style="font-size: 15px; line-height: 21px;"> you haven’t set the root password yet, the password will be blank,</div> <div style="font-size: 15px; line-height: 21px;"> so you should just press enter here.</div> <div style="font-size: 15px; line-height: 21px;"> <b>Enter current password for root (enter for none):       (type password here if you already generate root password or hit enter if not )</b></div> <div style="font-size: 15px; line-height: 21px;"> OK, successfully used password, moving on…</div> <div style="font-size: 15px; line-height: 21px;"> Setting the root password ensures that nobody can log into the MySQL</div> <div style="font-size: 15px; line-height: 21px;"> root user without the proper authorisation.</div> <div style="font-size: 15px; line-height: 21px;"> You already have a root password set, so you can safely answer ‘n’.</div> <div style="font-size: 15px; line-height: 21px;"> <b>Change the root password? [Y/n] y</b></div> <div style="font-size: 15px; line-height: 21px;"> New password:</div> <div style="font-size: 15px; line-height: 21px;"> Re-enter new password:</div> <div style="font-size: 15px; line-height: 21px;"> Password updated successfully!</div> <div style="font-size: 15px; line-height: 21px;"> Reloading privilege tables..</div> <div style="font-size: 15px; line-height: 21px;"> … Success!</div> <div style="font-size: 15px; line-height: 21px;"> By default, a MySQL installation has an anonymous user, allowing anyone</div> <div style="font-size: 15px; line-height: 21px;"> to log into MySQL without having to have a user account created for</div> <div style="font-size: 15px; line-height: 21px;"> them.  This is intended only for testing, and to make the installation</div> <div style="font-size: 15px; line-height: 21px;"> go a bit smoother.  You should remove them before moving into a</div> <div style="font-size: 15px; line-height: 21px;"> production environment.</div> <div style="font-size: 15px; line-height: 21px;"> <b>Remove anonymous users? [Y/n] y</b></div> <div style="font-size: 15px; line-height: 21px;"> … Success!</div> <div style="font-size: 15px; line-height: 21px;"> Normally, root should only be allowed to connect from ‘localhost’.  This</div> <div style="font-size: 15px; line-height: 21px;"> ensures that someone cannot guess at the root password from the network.</div> <div style="font-size: 15px; line-height: 21px;"> <b>Disallow root login remotely? [Y/n] y</b></div> <div style="font-size: 15px; line-height: 21px;"> … Success!</div> <div style="font-size: 15px; line-height: 21px;"> By default, MySQL comes with a database named ‘test’ that anyone can</div> <div style="font-size: 15px; line-height: 21px;"> access.  This is also intended only for testing, and should be removed</div> <div style="font-size: 15px; line-height: 21px;"> before moving into a production environment.</div> <div style="font-size: 15px; line-height: 21px;"> <b>Remove test database and access to it? [Y/n] y</b></div> <div style="font-size: 15px; line-height: 21px;"> – Dropping test database…</div> <div style="font-size: 15px; line-height: 21px;"> … Success!</div> <div style="font-size: 15px; line-height: 21px;"> – Removing privileges on test database…</div> <div style="font-size: 15px; line-height: 21px;"> … Success!</div> <div style="font-size: 15px; line-height: 21px;"> Reloading the privilege tables will ensure that all changes made so far</div> <div style="font-size: 15px; line-height: 21px;"> will take effect immediately.</div> <div style="font-size: 15px; line-height: 21px;"> <b>Reload privilege tables now? [Y/n] y</b></div> <div style="font-size: 15px; line-height: 21px;"> … Success!</div> <div style="font-size: 15px; line-height: 21px;"> Cleaning up..</div> <div style="font-size: 15px; line-height: 21px;"> All done!  If you’ve completed all of the above steps, your MySQL</div> <div style="font-size: 15px; line-height: 21px;"> installation should now be secure.</div> <div style="font-size: 15px; line-height: 21px;"> Thanks for using MySQL!</div> <div style="text-align: left;"> <span style="font-size: 15px; line-height: 21px;"><br /></span></div> <div style="text-align: left;"> <span style="font-size: 15px; line-height: 21px;"><b>Login into MySQL Database</b></span></div> <div> <strong style="background-color: white; font-size: 15px; line-height: 23px;">Login in to MySQL database as root user</strong></div> <div> <strong style="background-color: white; font-size: 15px; line-height: 23px;"><br /></strong></div> <div> <span style="background-color: white;"><div style="font-size: 15px; line-height: 23px;"> [root@master ~]# mysql -u root –p</div> <div style="font-size: 15px; line-height: 23px;"> Password: *******</div> <div style="font-size: 15px; line-height: 23px;"> output;</div> <div style="font-size: 15px; line-height: 23px;"> Welcome to the MySQL monitor.  Commands end with ; or \g.</div> <div style="font-size: 15px; line-height: 23px;"> Your MySQL connection id is 17</div> <div style="font-size: 15px; line-height: 23px;"> Server version: 5.1.73 Source distribution</div> <div style="font-size: 15px; line-height: 23px;"> Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.</div> <div style="font-size: 15px; line-height: 23px;"> Oracle is a registered trademark of Oracle Corporation and/or its</div> <div style="font-size: 15px; line-height: 23px;"> affiliates. Other names may be trademarks of their respectiveowners.</div> <div style="font-size: 15px; line-height: 23px;"> Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.</div> <div style="font-size: 15px; line-height: 23px;"> <br /></div> <div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>mysql></strong></div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>Exit from MySQL database</strong></div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <span style="font-size: 15px; line-height: 23px;">mysql> exit;</span></div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <span style="font-size: 15px; line-height: 23px;">Bye</span></div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> </div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <span style="font-size: 15px; line-height: 23px;">[root@master ~]#</span></div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <span style="font-size: 15px; line-height: 23px;">Note: After settings the mysql root password from bash sehll, clear the password  history from  </span><strong style="font-size: 15px; line-height: 23px;">.bash_history</strong><span style="font-size: 15px; line-height: 23px;">file</span></div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <strong style="font-size: 15px; line-height: 23px;">Shell/bash command history saved in</strong></div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <span style="font-size: 15px; line-height: 23px;">[root@master ~]# vim .bash_history</span></div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <strong style="font-size: 15px; line-height: 23px;">MySQL database queryhistory saved in</strong></div> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <span style="font-size: 15px; line-height: 23px;">[root@master ~]# vim .mysql_history</span></div> <h2 style="margin-bottom: 23px; position: relative; text-align: left; top: -9px;"> <span style="font-size: 15px; line-height: 23px;">MySQL Data type reference</span></h2> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <strong style="font-size: 15px; line-height: 23px;">Numeric Data Types</strong></div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> </div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>TinyInt</strong> – A very small integer with a signed range of -128 to 127 and an unsigned range of 0 to 255 .</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>SmallInt</strong> – A small integer with a signed range of -32768 to 32767 and an unsigned range of 0 to 65535 .</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>MediumInt</strong>– A medium sized integer with a signed range of -8388608 to 8388607 and an unsigned range of 0 to 16777215 .</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>Int</strong> (Integer) – It can store 0 to 255 characters.  holds a fixed length string (can contain letters, numbers, and special characters). The fixed size is specified in parenthesis.</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>Bigint</strong>–  A large integer with a signed range of -9223372036854775808 to 9223372036854775807 and an unsigned range of 0 to 18446744073709551615.</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>String/text Datatype</strong></div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>VARCHAR(size) –</strong>It Holds a variable length string (letters, numbers, and special characters). The maximum size is specified in parenthesis. Can store up to 255 characters.</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>CHAR(size) – </strong>Holds a fixed length string (can contain letters, numbers, and special characters). The fixed size is specified in parenthesis. Can store up to 255 characters</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>Date and Time data type</strong></div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>DATE     </strong>YYYY-MM-DD</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>DATETIME  </strong>YYYY-MM-DD HH:MM:SS</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>TIMESTAMP   </strong>YYYYMMDDHHMMSS</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>TIME  </strong>HH:MM:SS</div> <h2 style="margin-bottom: 23px; position: relative; text-align: left; top: -9px;"> <span style="font-size: 15px; line-height: 23px;">Database Storage engines</span></h2> <div style="margin-bottom: 23px; position: relative; top: -9px;"> <span style="font-size: 15px; line-height: 23px;">MySQL provides support for different storage engines which act as varying table type handlers. Two most common storage engines are MyISAM and InnoDB. Most of the time, the default storage engine as defined by the store_engine option in the MySQL config file is typically MyISAM.</span></div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> </div> <ul style="font-size: 15px; line-height: 23px; margin: 0px 0px 10.5px 25px; padding: 0px;"> <li style="line-height: 21px;">MyISAM</li> <li style="line-height: 21px;">InnoDB</li> <li style="line-height: 21px;">MERGE</li> <li style="line-height: 21px;">MEMORY (HEAP)</li> <li style="line-height: 21px;">ARCHIVE</li> <li style="line-height: 21px;">CSV</li> </ul> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <br /></div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>Differents between MyISAM and InnoDB.</strong></div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>MyISAM – </strong>This manages non transactional tables, provides high-speed storage and retrieval, supports full text searching.</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <strong>InnoDB –</strong>It provides transaction-safe (ACID compliant) tables, supports FOREIGN KEY referential-integrity constraints. It supports commit, rollback, and crash-recovery capabilities to protect data.</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> —</div> <div style="font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> This is all about basic concept of MySQL database server to perform some administration task, later we will post some useful MySQL command in our next tutorial.</div> </div> </span></div> </span></div> </div> </div>

MySQL database server Installation, Configuration in Linux

MySQL Database Points This tutorial explain about MySQL database running on a Linux server. This tutorial will make you understand h...

Read more »

Create Roaming User profile in Samba 4

<div dir="ltr" style="text-align: left;" trbidi="on"> <img alt="" class="entry-thumb" height="525" itemprop="image" src="http://linuxgateway.in/wp-content/uploads/2015/05/create-rom-samba-700x525.jpg" style="background-color: white; border: 0px; color: #4b4b4b; font-family: 'PT Sans', sans-serif; font-size: 14px; height: auto; line-height: 21px; max-width: 100%; vertical-align: middle;" title="create rom samba" width="700" /><div> <h2 style="text-align: left;"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">A brief Introduction about Roaming Profile</span></strong></h2> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Roaming profiles</span></strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;"> are user<span class="apple-converted-space"> </span><strong>profiles</strong><span class="apple-converted-space"> which stores on server, that allows users with a computer joined to a Server (DC) to log on to any computer on the same network and access their profile data from server. This profile is slow than other profile while logon and logoff.  After log off user account all the data switch from client computer to server on user profile.</span><o:p></o:p></span></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> <b>Configuring Samba 4 Roaming Profiles</b></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Login on samba 4 server with root user and check few things:</span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Identify running process of samba</span></b><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal"> [root@server ~]#ps -ef | grep samba</div> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Identify on which ports and interfaces Samba is listening<o:p></o:p></span></strong></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> [root@server ~]#netstat -tunlp | grep samba</div> <div class="MsoNormal"> <br /></div> <div style="text-align: left;"> <b>Create one or more user in Active directory</b></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";"><br /></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-fareast-font-family: "Times New Roman";">Doamin user name: gopal and prabhat</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: Arial, sans-serif; font-size: 11.5pt; line-height: 17.25pt;">Create a directory called “</span><b style="line-height: 17.25pt;"><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">userprofiles</span></b><span style="color: #262626; font-family: Arial, sans-serif; font-size: 11.5pt; line-height: 17.25pt;">” inside “</span><b style="line-height: 17.25pt;"><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">/</span></b><span style="color: #262626; font-family: Arial, sans-serif; font-size: 11.5pt; line-height: 17.25pt;">” on samba 4 server</span></div> <div class="MsoNormal"> [root@server ~]# mkdir /userprofiles</div> <div class="MsoNormal"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;"><br /></span></div> <div class="MsoNormal"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Provide full permission to directory</span><o:p></o:p></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> root@server ~]#chmod 777 /userprofiles</div> <div class="MsoNormal"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;"><br /></span></div> <div class="MsoNormal"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Make an entry of created directory in “</span><strong><span style="font-family: "Arial","sans-serif";">smb.conf</span></strong>” file  for sharing purpose among users , where user profile will store on server.</div> <div class="MsoNormal"> <br /></div> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt;">[root@server ~]# vim /usr/local/samba/etc/smb.conf<o:p></o:p></span></div> <div class="MsoNoSpacing"> [userprofiles]<o:p></o:p></div> <div class="MsoNoSpacing"> path = /userprofiles<o:p></o:p></div> <div class="MsoNoSpacing"> read only = no<o:p></o:p></div> <div class="MsoNoSpacing"> valid users=  gopal</div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Now, Restart the samba daemon<o:p></o:p></span></strong></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> [root@server ~]# /usr/local/samba/sbin/samba</div> <div class="MsoNormal"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Or,</span><o:p></o:p></div> <div class="MsoNormal"> [root@server ~]# /usr/local/samba/sbin/samba</div> <div class="MsoNormal"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Or,</span><o:p></o:p></div> <div class="MsoNormal"> [root@server ~]# samba</div> <div class="MsoNormal"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Or,</span><o:p></o:p></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> [root@server ~]# smbcontrol all reload-config</div> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Test now<o:p></o:p></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> [root@server ~]# kinit <a href="mailto:administrator@KVIT.IN">administrator@KVIT.IN</a></div> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">Check the available  shared directory<o:p></o:p></span></strong></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> [root@server ~]# smbclient -L localhost -U%</div> <div class="MsoNoSpacing"> Domain=[KVIT] OS=[Windows 6.1] Server=[Samba 4.3.0pre1-GIT-d098b6c]</div> <div class="MsoNoSpacing"> Sharename       Type      Comment</div> <div class="MsoNoSpacing"> ———       —-      ——-</div> <div class="MsoNoSpacing"> netlogon          Disk</div> <div class="MsoNoSpacing"> sysvol              Disk</div> <div class="MsoNoSpacing"> userprofiles    Disk</div> <div class="MsoNoSpacing"> IPC$                 IPC       IPC Service (Samba 4.3.0pre1-GIT-d098b6c)</div> <div class="MsoNoSpacing"> Domain=[KVIT] OS=[Windows 6.1] Server=[Samba 4.3.0pre1-GIT-d098b6c]</div> <div class="MsoNoSpacing"> Server               Comment</div> <div class="MsoNoSpacing"> ———            ——-</div> <div class="MsoNoSpacing"> Workgroup       Master</div> <div class="MsoNoSpacing"> <br /></div> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt;">Now go to your windows client machine where you have installed the remote administration tool(AD)for your domain server and define users to whom you want set roaming profile and set the path where user profile will created on server.<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt;">Go to run prompt and type<span class="apple-converted-space"> </span><strong>dsa.msc</strong>  to open<span class="apple-converted-space"> </span><strong>Active Directory console</strong><span class="apple-converted-space"> </span>and set user profile path.<o:p></o:p></span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJG7FSC6Fcz1rxqVqZaupiaDC1Pq1JGYtK0YgXuOzVYXPN5DCmGCDMbBC7OEMbOqGvhETop1EDJ4qQPmSO9uLnDX5vUvjUYkwkI7ADFKsHW2EiDGgtxI73gb26Clo5OcBpII3PJQZP5Gk/s1600/ad1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="207" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJG7FSC6Fcz1rxqVqZaupiaDC1Pq1JGYtK0YgXuOzVYXPN5DCmGCDMbBC7OEMbOqGvhETop1EDJ4qQPmSO9uLnDX5vUvjUYkwkI7ADFKsHW2EiDGgtxI73gb26Clo5OcBpII3PJQZP5Gk/s320/ad1.png" width="320" /></a></div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> <br /></div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> Now login in to client machine with domain user and check whether user profile is created or not on server and after user logout all user profile will be shift on server.</div> <div style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px; margin-bottom: 23px; position: relative; top: -9px;"> Login with above define roaming profile on client machine</div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFfFrGEc67rkxWy_5UyDk30v72otZpZZOAJz9IwEFUmBDsJR7O7E2OSKU0AwB8qSzGMILJohtINkBjx81gKdr25yd0HUr7WAqF3rUICNsrrna55A1PxbDFe24rKgKYCnrPfasydXt0zVY/s1600/ad2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="256" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFfFrGEc67rkxWy_5UyDk30v72otZpZZOAJz9IwEFUmBDsJR7O7E2OSKU0AwB8qSzGMILJohtINkBjx81gKdr25yd0HUr7WAqF3rUICNsrrna55A1PxbDFe24rKgKYCnrPfasydXt0zVY/s320/ad2.png" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <strong style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">Now, check the status on server</strong></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;"><b><br /></b></span></span></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@server ~]# cd /userprofiles/</span></span></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@server userprofiles]# ls</span></span></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 23px;"></span></span></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">gopal.V2</span></span></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;"><br /></span></span></div> <div class="separator" style="clear: both;"> <strong style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">After logout</strong></div> <div class="separator" style="clear: both;"> <strong style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;"><br /></strong></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@server userprofiles]# cd gopal.V2/</span></span></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">[root@server gopal.V2]# ls</span></span></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;"><b>output:</b></span></span></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 23px;"></span></span></div> <div class="separator" style="clear: both;"> <span style="color: #262626; font-family: PT Sans, sans-serif;"><span style="font-size: 15px; line-height: 23px;">AppData  Contacts  Desktop  Documents  Downloads  Favorites  Links  Music  NTUSER.DAT  ntuser.ini  Pictures  Saved Games  Searches  Videos</span></span></div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> <span style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">Now, successfully </span><strong style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;">roaming user profile</strong><span style="background-color: white; color: #262626; font-family: 'PT Sans', sans-serif; font-size: 15px; line-height: 23px;"> is shifted on server</span></div> </div> </div>

Create Roaming User profile in Samba 4

A brief Introduction about Roaming Profile Roaming profiles  are user   profiles  which stores on server, that allows users with a co...

Read more »

Samba 4 – Active Directory Domain Controller on Centos -6.x

<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="entry-thumb" height="525" itemprop="image" src="http://linuxgateway.in/wp-content/uploads/2015/05/Samba-4-domain-controller-700x525.jpg" style="background-color: white; border: 0px; color: #4b4b4b; font-size: 14px; height: auto; line-height: 21px; max-width: 100%; vertical-align: middle;" title="Samba 4 domain controller" width="700" /></span><br /> <br /> <div class="MsoNormal"> <b><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Introduction of Samba- 4<o:p></o:p></span></b></div> <div class="MsoNormal"> <span style="background: white; font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="background: white; font-family: "Arial","sans-serif";">Samba 4 is an open source and free software suit that brings Active Directory functionality to the open source SMB/CIFS (Server Message Block/Common Internet File System) file and print server. Samba 4 can serve as an Active Directory Domain Controller, provide DNS services, handle Kerberos-based authentication, and administer group policy.</span><o:p></o:p></div> <div class="MsoNormal"> <b><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></b></div> <div class="MsoNormal"> <b><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Samba4 Server Features<o:p></o:p></span></b></div> <div class="MsoNormal"> <span style="background: white; font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="background: white; font-family: "Arial","sans-serif";">1).Can act as ADDC(Active Directory Domain Controller)</span><span style="font-family: "Arial","sans-serif";"><br /> <span style="background: white;">2). Can create Local Profile in samba-4</span><br /> <span style="background: white;">3). Can create Roaming Profile in samba-4</span><br /> <span style="background: white;">4). Auto logon scripts</span><br /> <span style="background: white;">5). Centralized system administration using Group policy<o:p></o:p></span></span></div> <div class="MsoNormal"> <b><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></b></div> <div class="MsoNormal"> <b><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Server Information<o:p></o:p></span></b></div> <div class="MsoNormal"> <span style="background: white; font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="background: white; font-family: "Arial","sans-serif";">Operrating System: Centos6.3 64 bit</span><span style="font-family: "Arial","sans-serif";"><br /> <span style="background: white;">IP Address: 192.168.0.69</span><br /> <span style="background: white;">FQDN : server.kvit.in</span><br /> <span style="background: white;">Domain Name: kvit.in</span><br /> <span style="background: white;">Selinux : Disabled</span><br /> <span style="background: white;">DNS Forwarding IP Address:8.8.8.8 ( Change to yours)<o:p></o:p></span></span></div> <div class="MsoNormal"> <b><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></b></div> <div class="MsoNormal"> <b><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Installation step<o:p></o:p></span></b></div> <div class="MsoNormal"> <b><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></b></div> <div class="MsoNormal"> <b><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Install all dependencies package to build system samba-4<o:p></o:p></span></b></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# yum install glibc glibc-devel gcc python* libacl-devel krb5-workstation krb5-libs pam_krb5 libldap2-dev openldap-devel wget<o:p></o:p></span></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Query old available rpm package of samba<o:p></o:p></span></strong></div> <div class="MsoNormal"> <span style="font-family: Arial, sans-serif;"><br /></span></div> <div class="MsoNormal"> <span style="font-family: Arial, sans-serif;">[root@server ~]# rpm -qa | grep samba</span></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">If package are available remove them with YUM<o:p></o:p></span></strong></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# yum remove samba-winbind-client samba-common samba-client<o:p></o:p></span></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Install git to dowload the latest Samba 4 version<o:p></o:p></span></strong></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# yum install git-core<o:p></o:p></span></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Download the latest version of samba from git repository<o:p></o:p></span></strong></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# git clone git://git.samba.org/samba.git samba-master<o:p></o:p></span></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Reboot the server as a precaution so that all packages or kernel updates will be applied<o:p></o:p></span></strong></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">[root@server ~]#shutdown -r now<o:p></o:p></span></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Login again as root to build samba and then compile samba package<o:p></o:p></span></strong></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">[root@server ~]#cd samba-master<o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">[root@server ~]#./configure –enable-debug –enable-selftest<o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">[root@server ~]#make<o:p></o:p></span></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">If everything reports okay you can then install samba<o:p></o:p></span></strong></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">[root@server ~]#make install<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;"><br /></span></div> <div class="MsoNormal"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">You should now have samba installed to ‘</span><strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">/usr/local/samba</span></strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">‘<o:p></o:p></span></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Provision Samba 4 steps</span></strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">: <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">The provision step sets up a basic user database, and is used when you are setting up your Samba4 server in its own domain.</span><o:p></o:p></span></div> <div class="MsoNormal"> <b><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></b></div> <div class="MsoNormal"> <b><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Issue this command from root:</span><o:p></o:p></b></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# /usr/local/samba/bin/samba-tool domain provision<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Realm [KVIT.IN]: (press Enter)<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Domain [KVIT]: (press Enter)<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Server Role (dc, member, standalone) [dc]: (press Enter)<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">DNS backend (SAMBA_INTERNAL, BIND9_FLATFILE, BIND9_DLZ, NONE) [SAMBA_INTERNAL]: (press Enter)<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">DNS forwarder IP address (write ‘none’ to disable forwarding) [8.8.8.8]: (press Enter)<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Administrator password:********* (Set Here DC Administrator password)<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Retype password: *********<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Result will show like this<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Creating CN=MicrosoftDNS,CN=System,DC=kvit,DC=in<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Creating DomainDnsZones and ForestDnsZones partitions<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Populating DomainDnsZones and ForestDnsZones partitions<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Setting up sam.ldb rootDSE marking as synchronized<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Fixing provision GUIDs<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">A Kerberos configuration suitable for Samba 4 has been generated at /usr/local/samba/private/krb5.conf<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Once the above files are installed, your Samba4 server will be ready to use<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Server Role: active directory domain controller<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Hostname: server<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">NetBIOS Domain: KVIT<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">DNS Domain: kvit.in<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">DOMAIN SID: S-1-5-21-1541916875-3099074859-2332263890<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Note</span></strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt; line-height: 115%;">: </span><span style="background: white; font-family: "Arial","sans-serif";">You may need to remove the ‘/usr/local/samba/etc/smb.conf’ file if you are re-running the provision command. If you encounter any errors when running the provision command, you may need to install the necessary missing packages or fix errors and then run ‘./configure’, ‘make’ and ‘make install’ commands again as stated above. Remember to do a ‘make clean’ in the root of your ‘samba-master’ directory before running ‘make’ again.</span><o:p></o:p></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">If the provision setup was successful reboot the server<o:p></o:p></span></strong></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> [root@server ~]#shutdown -r now</div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></strong></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Start samba daemon manually<o:p></o:p></span></strong></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> [root@server ~]# /usr/local/samba/sbin/samba</div> <div class="MsoNormal"> <br /></div> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">If you like to start samba at boot time, Add</span><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt;"> </span><span style="font-family: "Arial","sans-serif"; font-size: 11.5pt;">‘<strong>/usr/local/samba/sbin/samba’</strong><span class="apple-converted-space"><b><span style="color: #262626;"> </span></b></span></span><span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">in /etc/rc.local file.<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]#vim /etc/rc.local<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">/usr/local/samba/sbin/samba<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNormal"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Verify you are indeed running the correct version<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# /usr/local/samba/sbin/samba -V<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Version 4.3.0pre1-GIT-d098b6c<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">Now run this command to list the shares on your Samba4 server<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# /usr/local/samba/bin/smbclient -L localhost -U%<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Domain=[KVIT] OS=[Windows 6.1] Server=[Samba 4.3.0pre1-GIT-d098b6c]<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Sharename Type Comment<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">——— —- ——-<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">netlogon Disk<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">sysvol Disk<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">IPC$ IPC IPC Service (Samba 4.3.0pre1-GIT-d098b6c)<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Domain=[KVIT] OS=[Windows 6.1] Server=[Samba 4.3.0pre1-GIT-d098b6c]<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Server Comment<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">——— ——-<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Workgroup Master<o:p></o:p></span></div> <div class="MsoNormal"> </div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">——— ——-</span></div> <h2 style="text-align: left;"> <b><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt;">Configure DNS Now</span></b></h2> <div class="MsoNoSpacing"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">Interface settings<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth0<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">DEVICE=”eth0″<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">BOOTPROTO=”static”<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">ONBOOT=”yes”<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">TYPE=”Ethernet”<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">GATEWAY=”192.168.0.254″<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">IPADDR=”192.168.0.69″<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">NETMASK=255.255.255.0<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt;">Edit your </span><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">‘</span><strong><span style="font-family: "Arial","sans-serif";">/etc/resolv.conf</span></strong><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt;">‘ file<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# vim /etc/resolv.conf<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">domain kvit.in<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">nameserver 192.168.0.69<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="background: white; font-family: "Arial","sans-serif";">Here is configuration file of samba 4</span><span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt;"> </span><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">‘</span><strong><span style="font-family: "Arial","sans-serif";">/usr/local/samba/etc/smb.conf</span></strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 11.5pt;">‘</span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# cat /usr/local/samba/etc/smb.conf<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";"># Global parameters<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[global]<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">workgroup = KVIT<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">realm = KVIT.IN<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">netbios name = SERVER<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">server role = active directory domain controller<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">dns forwarder = 8.8.8.8<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[netlogon]<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">path = /usr/local/samba/var/locks/sysvol/kvit.in/scripts<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">read only = No<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[sysvol]<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">path = /usr/local/samba/var/locks/sysvol<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">read only = No<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">Test DNS Now<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# nslookup kvit.in<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Server: 192.168.0.69<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Address: 192.168.0.69#53<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Name: kvit.in<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Address: 192.168.0.69<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# host -t SRV _ldap._tcp.kvit.in.<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">_ldap._tcp.kvit.in has SRV record 0 100 389 server.kvit.in.<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# host -t SRV _kerberos._udp.kvit.in.<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">_kerberos._udp.kvit.in has SRV record 0 100 88 server.kvit.in.<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# host -t A server.kvit.in.<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">server.kvit.in has address 192.168.0.69<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">Now, Flush and save Iptables<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# iptables -F<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# service iptables save<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# service iptables restart<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">Configure Kerberos file<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="background: white; font-family: "Arial","sans-serif";">In CentOS 6.3 or 6.4, kerberos is handled by the ‘/etc/krb5.conf’ file. Make a backup copy of this original file, and then replace the existing file, if any, with the sample from /usr/local/samba/share/setup/krb5.conf.</span><o:p></o:p></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# cp /usr/local/samba/share/setup/krb5.conf /etc/krb5.conf<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Edit file like below:<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# cat /etc/krb5.conf<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[libdefaults]<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">default_realm = KVIT.IN<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">dns_lookup_realm = false<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">dns_lookup_kdc = true<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">Testing Kerberos<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# kinit <a href="mailto:administrator@KVIT.IN">administrator@KVIT.IN</a><o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="background: white; color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt;">‘kinit’ will not give you any output. To verify that Kerberos is working, and that you received a ticket, run the following</span><o:p></o:p></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# klist<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Ticket cache: FILE:/tmp/krb5cc_0<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Default principal: administrator@KVIT.IN<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">Valid starting     Expires            Service principal<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">04/26/15 01:04:46  04/26/15 11:04:46  krbtgt/KVIT.IN@KVIT.IN<o:p></o:p></span></div> <div class="MsoNoSpacing"> </div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">renew until 04/27/15 01:04:41</span></div> <h2 style="text-align: left;"> <b><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt;">NTP (Network Time Protocol)</span></b></h2> <div class="MsoNoSpacing"> <span style="background: white; font-family: "Arial","sans-serif";">Make sure that ‘ntpd’ is running and installed. If ‘ntpd’ is not installed you can install it with YUM:</span><o:p></o:p></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# yum install ntp<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]#/etc/init.d/ntpd start<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="background: white; font-family: "Arial","sans-serif";">Also, use the ‘chkconfig’ command to have ntpd run at boot:</span><o:p></o:p></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]#chkconfig ntpd on<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# /usr/local/samba/sbin/samba<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">Put samba 4 command in bashrc<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# vi ~/.bashrc<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">export PATH=$PATH:/usr/local/samba/sbin:/usr/local/samba/bin<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="background: white; font-family: "Arial","sans-serif";">Reboot the the server to update bashrc file</span><o:p></o:p></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="background: white; font-family: "Arial","sans-serif";">or,</span><o:p></o:p></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# bash<o:p></o:p></span></div> <div class="MsoNoSpacing"> <span style="background: white; font-family: "Arial","sans-serif";">Now restart samba daemon like this</span><o:p></o:p></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# samba<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <strong><span style="background: white; font-family: "Arial","sans-serif"; font-size: 12.0pt;">Check the process of samba service<o:p></o:p></span></strong></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> </div> <div class="MsoNoSpacing"> <span style="font-family: "Arial","sans-serif";">[root@server ~]# ps -ef | grep samba<o:p></o:p></span></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNoSpacing"> <b><span style="font-family: "Arial","sans-serif"; font-size: 12.0pt;">Join windows system in Domain<o:p></o:p></span></b></div> <div class="MsoNoSpacing"> <br /></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <b><span style="font-family: "Arial","sans-serif"; mso-fareast-font-family: "Times New Roman";">Client machine settings</span></b><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div> <div class="MsoNoSpacing"> </div> <div class="MsoNormal" style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; mso-fareast-font-family: "Times New Roman";">IP address settings of your Windows 7 client NIC</span></div> <a href="http://linuxgateway.in/wp-content/uploads/2015/04/ip-settings1.png" style="background-color: white; color: #4db2ec; font-size: 15px; line-height: 23px; text-decoration: none !important;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="ip settings" class="alignnone size-medium wp-image-439" height="300" src="http://linuxgateway.in/wp-content/uploads/2015/04/ip-settings1-269x300.png" style="border: 0px; display: block; height: auto; max-width: 100%; vertical-align: middle;" width="269" /></span></a><br /> <div class="MsoNormal" style="background: white; line-height: 17.25pt;"> <span style="font-family: "Arial","sans-serif"; mso-fareast-font-family: "Times New Roman";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">Click ‘OK’ to save the changes.</span><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 115%;"><o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">Now bring up a command prompt in windows and ping the Samba DC:</span><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 115%;"><o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">ping 192.168.0.69</span><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 115%;"><o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">Verify that DNS is working correctly by pinging the FQDN:</span><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 115%;"><o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">ping server.kvit.in</span><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 115%;"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt;"> </div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";"><br /></span></div> <div class="MsoNormal"> <span style="font-family: "Arial","sans-serif";">If you get replies from both then this is a good sign and should mean that your Samba DC is functional. Also, you may need to reboot Windows for network settings to take effect.</span><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 115%;"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.25pt;"> <span style="font-family: "Arial","sans-serif"; mso-fareast-font-family: "Times New Roman";"><br /></span></div> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <strong style="line-height: 17.25pt;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; font-family: Arial, sans-serif; font-size: 12pt;">Configure data and time on client system</span></strong></div> <a href="http://linuxgateway.in/wp-content/uploads/2015/04/Date-and-time.png" style="background-color: white; color: #4db2ec; font-size: 15px; line-height: 23px; text-decoration: none !important;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="Date and time" class="alignnone size-medium wp-image-440" height="300" src="http://linuxgateway.in/wp-content/uploads/2015/04/Date-and-time-293x300.png" style="border: 0px; display: block; height: auto; max-width: 100%; vertical-align: middle;" width="293" /></span></a><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <strong><span style="color: #262626; font-family: "Arial","sans-serif";">Join windows client in to domain</span></strong><span style="color: #262626; font-family: "Arial","sans-serif";"><o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.0pt;">1). Right-click ‘My Computer’ icon and choose ‘Properties’<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.0pt;">2). From the left-side pane click ‘Advanced system settings’<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.0pt;">3). Choose the ‘Computer Name’ tab and click ‘Change…’<o:p></o:p></span></div> <br /> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.0pt;">4). Select option ‘Domain’, and insert KVIT.IN. If this fails just try<span class="apple-converted-space"> </span><strong>KVIT</strong><o:p></o:p></span></div> <a href="http://linuxgateway.in/wp-content/uploads/2015/04/join-in-domain.png" style="background-color: white; color: #4db2ec; font-size: 15px; line-height: 23px; text-decoration: none !important;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="join in domain" class="alignnone size-medium wp-image-444" height="215" src="http://linuxgateway.in/wp-content/uploads/2015/04/join-in-domain-300x215.png" style="border: 0px; display: block; height: auto; max-width: 100%; vertical-align: middle;" width="300" /></span></a><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">5). When it requests a username and password, type ‘Administrator’ as the username and then enter your password. (password = the password you used when you ran the ‘samba-tool domain provision’ command)<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">6). You should get a message box stating ‘Welcome to the KVIT.IN domain’<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">7). Click OK on this message box and the Properties window, and you will then be instructed to restart your computer.<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">8). After restarting you should be presented with the normal login dialog. Click on ‘Switch User’ button.<o:p></o:p></span></div> <br /> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">9). Choose ‘Other user’ and then enter in the following</span><span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.5pt;">.<o:p></o:p></span></div> <a href="http://linuxgateway.in/wp-content/uploads/2015/04/login.png" style="background-color: white; color: #4db2ec; font-size: 15px; line-height: 23px; text-decoration: none !important;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="login" class="alignnone size-medium wp-image-446" height="245" src="http://linuxgateway.in/wp-content/uploads/2015/04/login-300x245.png" style="border: 0px; display: block; height: auto; max-width: 100%; vertical-align: middle;" width="300" /></span></a><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Press ‘Enter’ or the arrow button.<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">10). You should then authenticate and then login to Windows.<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <strong><span style="font-family: "Arial","sans-serif";">Install windows Remote Administration tool</span></strong><span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">To install the GUI tools to manage the domain you must install the Remote Server Administration Tools . This will allow you easily manage the domain using Active Directory.<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">11). Download form link:<span class="apple-converted-space"> </span><a href="http://www.microsoft.com/en-us/download/details.aspx?id=7887"><span style="color: windowtext;">http://www.microsoft.com/en-us/download/details.aspx?id=7887</span></a><o:p></o:p></span></div> <br /> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">12).Enable the necessary components in ‘Control Panel -> Programs -> Turn Windows features on or off -> Remote Server Administration Tools’</span></div> <a href="http://linuxgateway.in/wp-content/uploads/2015/04/Enable-remote-tool.png" style="background-color: white; color: #4db2ec; font-size: 15px; line-height: 23px; text-decoration: none !important;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="Enable remote tool" class="alignnone size-medium wp-image-447" height="263" src="http://linuxgateway.in/wp-content/uploads/2015/04/Enable-remote-tool-300x263.png" style="border: 0px; display: block; height: auto; max-width: 100%; vertical-align: middle;" width="300" /></span></a><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.0pt;">13). Now open AD Console and create one or more domain user<o:p></o:p></span></div> <br /> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="color: #262626; font-family: "Arial","sans-serif"; font-size: 11.0pt;">Go to Run type : dsa.msc ( For AD console)</span></div> <a href="http://linuxgateway.in/wp-content/uploads/2015/04/AD-Console.png" style="background-color: white; color: #4db2ec; font-size: 15px; line-height: 23px; text-decoration: none !important;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="AD Console" class="alignnone size-medium wp-image-449" height="232" src="http://linuxgateway.in/wp-content/uploads/2015/04/AD-Console-300x232.png" style="border: 0px; display: block; height: auto; max-width: 100%; vertical-align: middle;" width="300" /></span></a><br /> <div> <br /></div> <div> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">14). Now create a domain user to login in to system<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">R/c on User ==> New ==> User:<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">First Name: Shahzad<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Last Name: Alam<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">User Logon name: shahzad<o:p></o:p></span></div> <div style="background: white; line-height: 17.25pt; margin: 0in 0in 17.25pt;"> <span style="font-family: "Arial","sans-serif"; font-size: 11.0pt;">Set user password: ******* (Minimum password length should be 7 and complex)</span></div> <div style="background: white; line-height: 17.25pt; margin-bottom: 17.25pt; margin-left: 0in; margin-right: 0in; margin-top: 0in;"> <strong><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; font-family: Arial, sans-serif;">Now, login in to client machine with new domain user</span></strong><span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div> </div> <div> <a href="http://linuxgateway.in/wp-content/uploads/2015/04/local-user-login.png" style="background-color: white; color: #4db2ec; font-size: 15px; line-height: 23px; text-decoration: none !important;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="local user login" class="alignnone size-medium wp-image-450" height="250" src="http://linuxgateway.in/wp-content/uploads/2015/04/local-user-login-300x250.png" style="border: 0px; display: block; height: auto; max-width: 100%; vertical-align: middle;" width="300" /></span></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> </div>

Samba 4 – Active Directory Domain Controller on Centos -6.x

Introduction of Samba- 4 Samba 4 is an open source and free software suit that brings Active Directory functionality to the open sou...

Read more »