tag:blogger.com,1999:blog-21060552358851887912011-07-28T13:14:27.339-07:00Nara Khahttp://www.blogger.com/profile/09079556578980931622noreply@blogger.comBlogger41100tag:blogger.com,1999:blog-2106055235885188791.post-37628052632465423122009-10-05T04:10:00.000-07:002009-10-16T20:25:50.878-07:00<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_iAYEOglb4Bo/SsnVPWvgd8I/AAAAAAAAACI/Gu6UA7q2BoY/s1600-h/untitled.JPG"><img id="BLOGGER_PHOTO_ID_5389072888905103298" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 330px; CURSOR: pointer; HEIGHT: 245px; TEXT-ALIGN: center" alt="" src="http://1.bp.blogspot.com/_iAYEOglb4Bo/SsnVPWvgd8I/AAAAAAAAACI/Gu6UA7q2BoY/s320/untitled.JPG" border="0" /></a> <br /><span style="FONT-WEIGHT: bold">Rumus data: <br />Satu Ke Satu : <br />Direktur :<span style="FONT-STYLE: italic">NIP,</span>Nama,Alamat. <br />Mengepalai :<span style="FONT-STYLE: italic">Nama Perusahaan</span>,Alamat Perusahaan. <br />Perusahaan :<span style="FONT-STYLE: italic">Kode Perusahaan</span>,Sertifikasi,Nama Perusahaan. <br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_iAYEOglb4Bo/SsnUuH3Gj5I/AAAAAAAAACA/b3GFoTbv-cE/s1600-h/klh.JPG"><img id="BLOGGER_PHOTO_ID_5389072317974744978" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 332px; CURSOR: pointer; HEIGHT: 249px; TEXT-ALIGN: center" alt="" src="http://2.bp.blogspot.com/_iAYEOglb4Bo/SsnUuH3Gj5I/AAAAAAAAACA/b3GFoTbv-cE/s320/klh.JPG" border="0" /></a><span style="font-family:georgia;font-size:100%;"><span style="FONT-WEIGHT: bold">Rumus Data</span><br style="FONT-WEIGHT: bold"><span style="FONT-WEIGHT: bold">Satu Ke banyak :</span></span> <br /><span style="FONT-WEIGHT: bold">Pelatih :</span><span style="FONT-WEIGHT: bold; FONT-STYLE: italic"> Nama Pelatih</span>,<span style="FONT-WEIGHT: bold">Asal Negara,Reputasi,Awal Masuk. <br />Strategi :<span style="FONT-STYLE: italic">Formasi,</span>Pergantian,Menang. <br />Team :<span style="FONT-STYLE: italic">Kapten,</span>Formasi,Pergantian,Lawan,Menang. <br /></span><meta content="text/html; charset=utf-8" equiv="Content-Type"><meta content="Word.Document" name="ProgId"><meta content="Microsoft Word 11" name="Generator"><meta content="Microsoft Word 11" name="Originator"><link style="FONT-WEIGHT: bold; FONT-FAMILY: georgia" href="file:///C:%5CDOCUME%7E1%5CCLIENT%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C06%5Cclip_filelist.xml" rel="File-List"><style> <!-- /* Font Definitions */ @font-face {font-family:Calibri; mso-font-alt:"Century Gothic"; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin-top:0cm; margin-right:0cm; margin-bottom:10.0pt; margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibri; mso-fareast-font-family:Calibri; mso-bidi-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_iAYEOglb4Bo/SsnUuH3Gj5I/AAAAAAAAACA/b3GFoTbv-cE/s1600-h/klh.JPG"></a><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_iAYEOglb4Bo/SsnUb15ZImI/AAAAAAAAAB4/beGyfdVXwzY/s1600-h/kha.JPG"><img id="BLOGGER_PHOTO_ID_5389072003914867298" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 331px; CURSOR: pointer; HEIGHT: 248px; TEXT-ALIGN: center" alt="" src="http://4.bp.blogspot.com/_iAYEOglb4Bo/SsnUb15ZImI/AAAAAAAAAB4/beGyfdVXwzY/s320/kha.JPG" border="0" /> </a><span style="font-family:georgia;"><span style="font-size:100%;"><span style="FONT-WEIGHT: bold">Rumus Data <br />Banyak Ke Banyak : <br />Band : <span style="FONT-STYLE: italic">Nama Band,</span>Asal Band,Tahun Berdiri,Nama personil. <br />Menyanyi :<span style="FONT-STYLE: italic">Pencipta</span>,Jenis Lagu,Judul Lagu. <br />Audience :<span style="FONT-STYLE: italic">Jumlah</span>,Nama Audience,Asal Audience. <br /></span></span></span> <br /><span style="font-family:georgia;font-size:100%;"><span style="FONT-WEIGHT: bold"></span></span> <br /><p class="MsoNormal" face="georgia"> <br /></p><p class="MsoNormal" style="FONT-FAMILY: georgia"><span style="font-size:100%;"><b><span lang="IN" style="LINE-HEIGHT: 115%;color:black;" > <br /></span></b></span></p> <br /><p class="MsoNormal"><b><span lang="IN" style="LINE-HEIGHT: 115%;font-size:12;color:black;" ><span style="font-size:+0;"> <br /></span></span></b></p><p class="MsoNormal"> <br /></p><p class="MsoNormal"> <br /><b><span lang="IN" style="LINE-HEIGHT: 115%;font-size:12;color:black;" ><span style="font-size:+0;"></span><?xml:namespace prefix = o /><o:p></o:p></span></b></p> <br /><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2106055235885188791-3762805263246542312?l=fidianarashikamaru.blogspot.com' alt='' /></div>Nara Khahttp://www.blogger.com/profile/09079556578980931622noreply@blogger.com0tag:blogger.com,1999:blog-2106055235885188791.post-36663981329007303782009-09-30T23:06:00.000-07:002009-10-02T23:50:41.027-07:00<div style="margin: 15px 5px 0px 0px; float: left;"> </div> <div class="antara section" id="ads1"> </div> <div class="antara section" id="ads2"> </div> <div style="text-align: center;"><span style="font-size: 180%;"><a style="color: rgb(255, 0, 0); font-weight: bold; font-family: lucida grande;" href="http://dwiki76.blogspot.com/2009/09/mysql.html">MySQL</a></span></div><h3 class="post-title"> </h3> <p>MySQL<br /> Cara Menguasai DDL</p><p>BAB6</p><p><br />mysql> CREATE TABLE jenis_barang (<br /> -> kd_jenis CHAR(3) NOT NULL PRIMARY KEY,<br /> -> nm_jenis VARCHAR(35) NOT NULL<br /> -> );<br />Query OK, 0 rows affected (0.20 sec)<br /><br />mysql> CREATE TABLE jenis_barang (<br /> -> kd_jenis CHAR(3) NOT NULL,<br /> -> nm_jenis VARCHAR(35) NOT NULL,<br /> -> PRIMARY KEY(kd_jenis)<br /> -> );<br />ERROR 1050 (42S01): Table 'jenis_barang' already exists<br />mysql> desc jenis_barang;<br />+----------+-------------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+----------+-------------+------+-----+---------+-------+<br />| kd_jenis | char(3) | NO | PRI | NULL | |<br />| nm_jenis | varchar(35) | NO | | NULL | |<br />+----------+-------------+------+-----+---------+-------+<br />2 rows in set (0.00 sec)<br /><br />mysql> drop table jenis_barang;<br />Query OK, 0 rows affected (0.03 sec)<br /><br />mysql> create table jenis_barang (<br /> -> kd_jenis int(3) not null auto_increment,<br /> -> nm_jenis varchar(35) not null,<br /> -> primary key(kd_jenis)<br /> -> );<br />Query OK, 0 rows affected (0.09 sec)<br /><br />mysql> desc jenis_barang;<br />+----------+-------------+------+-----+---------+----------------+<br />| Field | Type | Null | Key | Default | Extra |<br />+----------+-------------+------+-----+---------+----------------+<br />| kd_jenis | int(3) | NO | PRI | NULL | auto_increment |<br />| nm_jenis | varchar(35) | NO | | NULL | |<br />+----------+-------------+------+-----+---------+----------------+<br />2 rows in set (0.00 sec)<br /><br />mysql> alter table jenis_barang add deskripsi text<br /> -> after nm_jenis;<br />Query OK, 0 rows affected (0.45 sec)<br />Records: 0 Duplicates: 0 Warnings: 0<br /><br />mysql> desc jenis_barang;<br />+-----------+-------------+------+-----+---------+----------------+<br />| Field | Type | Null | Key | Default | Extra |<br />+-----------+-------------+------+-----+---------+----------------+<br />| kd_jenis | int(3) | NO | PRI | NULL | auto_increment |<br />| nm_jenis | varchar(35) | NO | | NULL | |<br />| deskripsi | text | YES | | NULL | |<br />+-----------+-------------+------+-----+---------+----------------+<br />3 rows in set (0.00 sec)<br /><br />mysql> alter table jenis_barang add<br /> -> kd_baru char(3) first;<br />Query OK, 0 rows affected (0.77 sec)<br />Records: 0 Duplicates: 0 Warnings: 0<br /><br />mysql> desc jenis_barang;<br />+-----------+-------------+------+-----+---------+----------------+<br />| Field | Type | Null | Key | Default | Extra |<br />+-----------+-------------+------+-----+---------+----------------+<br />| kd_baru | char(3) | YES | | NULL | |<br />| kd_jenis | int(3) | NO | PRI | NULL | auto_increment |<br />| nm_jenis | varchar(35) | NO | | NULL | |<br />| deskripsi | text | YES | | NULL | |<br />+-----------+-------------+------+-----+---------+----------------+<br />4 rows in set (0.02 sec)<br /><br />mysql> drop table jenis_barang;<br />Query OK, 0 rows affected (0.27 sec)<br /><br />mysql> create table jenis_barang (<br /> -> kd_jenis char(3) nott null,<br /> -> nm_jenis varchar(35) not null<br /> -> );<br />ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that<br />corresponds to your MySQL server version for the right syntax to use near 'nott<br />null,<br />nm_jenis varchar(35) not null<br />)' at line 2<br />mysql> create table jenis_barang (<br /> -> kd_jenis CHAR(3) NOT NULL,<br /> -> nm_jenis VARCHAR(35) NOT NULL<br /> -> );<br />Query OK, 0 rows affected (0.17 sec)<br /><br />mysql> desc jenis_barang;<br />+----------+-------------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+----------+-------------+------+-----+---------+-------+<br />| kd_jenis | char(3) | NO | | NULL | |<br />| nm_jenis | varchar(35) | NO | | NULL | |<br />+----------+-------------+------+-----+---------+-------+<br />2 rows in set (0.00 sec)<br /><br />mysql> alter table jenis_barang<br /> -> add primari key(kd_jenis);<br />ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that<br />corresponds to your MySQL server version for the right syntax to use near 'key(k<br />d_jenis)' at line 2<br />mysql> ALTER TABLE jenis_barang<br /> -> ADD PRIMARY KEY(kd_jenis);<br />Query OK, 0 rows affected (0.72 sec)<br />Records: 0 Duplicates: 0 Warnings: 0<br /><br />mysql> DESC jenis_barang;<br />+----------+-------------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+----------+-------------+------+-----+---------+-------+<br />| kd_jenis | char(3) | NO | PRI | NULL | |<br />| nm_jenis | varchar(35) | NO | | NULL | |<br />+----------+-------------+------+-----+---------+-------+<br />2 rows in set (0.00 sec)<br /><br />mysql> ALTER TABLE jenis_barang CHANGE nm_jenis<br /> -> nama_jenis VARCHAR(50) NOT NULL;<br />Query OK, 0 rows affected (0.47 sec)<br />Records: 0 Duplicates: 0 Warnings: 0<br /><br />mysql> DESC jenis_barang;<br />+------------+-------------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+------------+-------------+------+-----+---------+-------+<br />| kd_jenis | char(3) | NO | PRI | NULL | |<br />| nama_jenis | varchar(50) | NO | | NULL | |<br />+------------+-------------+------+-----+---------+-------+<br />2 rows in set (0.02 sec)<br /><br />mysql> SHOW TABLES;<br />+------------------+<br />| Tables_in_bab6db |<br />+------------------+<br />| jenis_barang |<br />| tipe_barang |<br />+------------------+<br />2 rows in set (0.00 sec)<br /><br />mysql> ALTER TABLE jenis_barang RENAME TO data_jenis;<br />Query OK, 0 rows affected (0.03 sec)<br /><br />mysql> SHOW TABLES;<br />+------------------+<br />| Tables_in_bab6db |<br />+------------------+<br />| data_jenis |<br />| tipe_barang |<br />+------------------+<br />2 rows in set (0.00 sec)<br /><br />mysql> ALTER TABLE data_jenis DROP PRIMARY KEY;<br />Query OK, 0 rows affected (0.42 sec)<br />Records: 0 Duplicates: 0 Warnings: 0<br /><br />mysql> DESC data_jenis;<br />+------------+-------------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+------------+-------------+------+-----+---------+-------+<br />| kd_jenis | char(3) | NO | | NULL | |<br />| nama_jenis | varchar(50) | NO | | NULL | |<br />+------------+-------------+------+-----+---------+-------+<br />2 rows in set (0.00 sec)<br /><br />mysql> ALTER TABLE data_jenis DROP nama_jenis;<br />Query OK, 0 rows affected (0.59 sec)<br />Records: 0 Duplicates: 0 Warnings: 0<br /><br />mysql> DESC data_jenis;<br />+----------+---------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+----------+---------+------+-----+---------+-------+<br />| kd_jenis | char(3) | NO | | NULL | |<br />+----------+---------+------+-----+---------+-------+<br />1 row in set (0.00 sec)<br /><br />mysql> RENAME DATABASE bab6db TO elektronikdb;<br />ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that<br />corresponds to your MySQL server version for the right syntax to use near 'DATAB<br />ASE bab6db TO elektronikdb' at line 1<br />mysql> RENAME bab6db to elektronikdb;<br />ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that<br />corresponds to your MySQL server version for the right syntax to use near 'bab6d<br />b to elektronikdb' at line 1<br />mysql> CREATE DATABASE elektronikdb;<br />Query OK, 1 row affected (0.00 sec)<br /><br />mysql> use elektronik;<br />ERROR 1049 (42000): Unknown database 'elektronik'<br />mysql> use elektronikdb;<br />Database changed<br />mysql> CREATE TABLE jenis_barang;<br />ERROR 1113 (42000): A table must have at least 1 column<br />mysql> CREATE TABLE siswa (<br /> -> nis CHAR (6) NOT NULL,<br /> -> nama VARCHAR(60) NOT NULL,<br /> -> kelamin ENUM('P','W'),<br /> -> gdarah ENUM('A','B','AB','O'),<br /> -> PRIMARY KEY(nis)<br /> -> );<br />Query OK, 0 rows affected (0.41 sec)<br /><br />mysql> desc siswa;<br />+---------+------------------------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+---------+------------------------+------+-----+---------+-------+<br />| nis | char(6) | NO | PRI | NULL | |<br />| nama | varchar(60) | NO | | NULL | |<br />| kelamin | enum('P','W') | YES | | NULL | |<br />| gdarah | enum('A','B','AB','O') | YES | | NULL | |<br />+---------+------------------------+------+-----+---------+-------+<br />4 rows in set (0.00 sec)<br /><br />mysql> CREATE TABLE siswa2 (<br /> -> nis CHAR (6) NOT NULL,<br /> -> nama VARCHAR(60) NOT NUll,<br /> -> tgl_lahir DATE,<br /> -> PRIMARY KEY(nis)<br /> -> );<br />Query OK, 0 rows affected (0.39 sec)<br /><br />mysql> desc siswa2;<br />+-----------+-------------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+-----------+-------------+------+-----+---------+-------+<br />| nis | char(6) | NO | PRI | NULL | |<br />| nama | varchar(60) | NO | | NULL | |<br />| tgl_lahir | date | YES | | NULL | |<br />+-----------+-------------+------+-----+---------+-------+<br />3 rows in set (0.02 sec)<br /><br />mysql> CREATE TABLE siswa3 (<br /> -> nis CHAR (6) NOT NULL,<br /> -> nama VARCHAR(60) NOT NULL,<br /> -> foto BLOB,<br /> -> PRIMARY KEY(nis)<br /> -> );<br />Query OK, 0 rows affected (0.22 sec)<br /><br />mysql> desc siswa3;<br />+-------+-------------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+-------+-------------+------+-----+---------+-------+<br />| nis | char(6) | NO | PRI | NULL | |<br />| nama | varchar(60) | NO | | NULL | |<br />| foto | blob | YES | | NULL | |<br />+-------+-------------+------+-----+---------+-------+<br />3 rows in set (0.00 sec)<br /><br />mysql> CREATE TABLE pesan (<br /> -> no_pesan CHAR(6) NOT NULL,<br /> -> id_anggota CHAR(5) NOT NULL,<br /> -> id_barang CHAR(5) NOT NULL,<br /> -> jumlah INT(2) DEFAULT '1',<br /> -> PRIMARY KEY (no_pesan)<br /> -> );<br />Query OK, 0 rows affected (0.44 sec)<br /><br />mysql> desc pesan;<br />+------------+---------+------+-----+---------+-------+<br />| Field | Type | Null | Key | Default | Extra |<br />+------------+---------+------+-----+---------+-------+<br />| no_pesan | char(6) | NO | PRI | NULL | |<br />| id_anggota | char(5) | NO | | NULL | |<br />| id_barang | char(5) | NO | | NULL | |<br />| jumlah | int(2) | YES | | 1 | |<br />+------------+---------+------+-----+---------+-------+<br />4 rows in set (0.00 sec)<br /><br />mysql> CREATE TABLE bukutamu (<br /> -> idtamu INT(-4-) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT ,<br /> -> nama VARCHAR(-60-) NOT NUL ,<br /> -> email VARCHAR(-60-) NOT NULL ,<br /> -> pesan TEXT NOT NULL,<br /> -> PRIMARY KEY (idtamu)<br /> -> );<br />ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that<br />corresponds to your MySQL server version for the right syntax to use near '-4-)<br />UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT ,<br />nama VARCHAR(-60-) NOT NUL ,<br />em' at line 2</p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2106055235885188791-3666398132900730378?l=fidianarashikamaru.blogspot.com' alt='' /></div>Nara Khahttp://www.blogger.com/profile/09079556578980931622noreply@blogger.com0tag:blogger.com,1999:blog-2106055235885188791.post-24742393454740062252009-09-02T18:54:00.000-07:002009-10-02T23:50:41.028-07:00<p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN">Instalasi dan Dasar Database MySQL<o:p></o:p></span></b></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;"><b style=""><span style="" lang="IN">Menginstal MySQL Versi 5.0<o:p></o:p></span></b></span></p> <!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" spt="75" preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:formulas> <v:path extrusionok="f" gradientshapeok="t" connecttype="rect"> <o:lock ext="edit" aspectratio="t"> </v:shapetype><v:shape id="Picture_x0020_1" spid="_x0000_s1026" type="#_x0000_t75" style="'position:absolute;left:0;text-align:left;margin-left:75.75pt;"> <v:imagedata src="file:///C:\DOCUME~1\VIKING\LOCALS~1\Temp\msohtml1\03\clip_image001.png" title=""> </v:shape><![endif]--><!--[if !vml]--><!--[endif]--><span style="font-size: 85%;" lang="IN"> 1. Jalankan </span><span style="font-size: 85%;">Klik dua kali</span><span style="font-size: 85%;" lang="IN"> file </span><span style="font-size: 85%;">Setup.exe, yang terdapat pada folder MySQL Server 5.0 .</span><span style="font-size: 85%; color: red;"> </span><span style="font-size: 85%; color: red;" lang="IN"><o:p></o:p></span> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="font-family: arial;"><img src="file:///C:/DOCUME%7E1/Ikok/LOCALS%7E1/Temp/moz-screenshot-1.png" alt="" /></p><img src="file:///C:/DOCUME%7E1/Ikok/LOCALS%7E1/Temp/moz-screenshot.png" alt="" /><p style="text-align: center; font-family: arial;" class="MsoNormal"><img src="file:///C:/Documents%20and%20Settings/Administrator/My%20Documents/instalasi%20mySQL/1.gif" alt="" /></p> <p class="ListParagraphCxSpFirst" style="margin-left: 14.2pt; font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="ListParagraphCxSpLast" style="margin-left: 14.2pt; font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <img src="file:///C:/DOCUME%7E1/Ikok/LOCALS%7E1/Temp/moz-screenshot-2.png" alt="" /><span style="font-size: 85%;" lang="IN">2. Klik ganda pada ikon program installer MySQL. Dari gambar diatas, anda dapat memilih dan klik ganda pada file yang bernama <span style="color: red;">Setup Wizard</span><o:p></o:p><br /></span><p class="ListParagraphCxSpFirst" style="margin-left: 14.2pt; font-family: arial;"><span style="font-size: 85%;" lang="IN">Sekarang anda akan mendapatkan halaman utama pertama penginstalan, klik tombol <b style=""><u>N</u>ext</b> untuk melanjutkan proses installasi.<o:p></o:p></span></p> <p class="ListParagraphCxSpLast" style="margin-left: 14.2pt; font-family: arial;"><!--[if gte vml 1]><v:shape id="_x0000_s1027" type="#_x0000_t75" style="'position:absolute;left:0;"> <v:imagedata src="file:///C:\DOCUME~1\VIKING\LOCALS~1\Temp\msohtml1\03\clip_image003.png" title=""> </v:shape><![endif]--><!--[if !vml]--><span style="font-size: 85%;"> </span><br /></p><p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><img src="file:///D:/Unduhan/instalasi-software-database-mysql-t102.0_files/01-Welcome.gif" alt="" border="0" /></p><img src="file:///D:/Unduhan/instalasi-software-database-mysql-t102.0_files/01-Welcome.gif" alt="" border="0" /><img src="file:///C:/DOCUME%7E1/Ikok/LOCALS%7E1/Temp/moz-screenshot-5.png" alt="" /><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-7.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /></div><p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><br /><span style="font-size: 85%;" lang="IN"><o:p></o:p></span></p><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"> 3. Setelah masuk pada halaman <b style="">Setup Type, </b>pilihlah <b style="">Typical </b>untuk jenis penginstalan yang akan kita gunakan. Berikut gambarnya <o:p></o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><!--[if gte vml 1]><v:shape id="Picture_x0020_4" spid="_x0000_s1028" type="#_x0000_t75" style="'position:absolute;left:0;text-align:left;"> <v:imagedata src="file:///C:\DOCUME~1\VIKING\LOCALS~1\Temp\msohtml1\03\clip_image005.png" title=""> </v:shape><![endif]--><!--[if !vml]--><span style="font-size: 85%;"><br /></span><!--[endif]--><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><br /></span></b></span></p><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-7.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /></div><p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><br /><span style="font-size: 85%;" lang="IN"><o:p></o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"> 4. </span><span style="font-size: 85%;">pada tampilan ini Anda harus memilih jenis instalasi yang akan dilaksanakan. Yang paling mudah adalah jenis instalasi <span style="font-weight: bold;">Typical</span>. Maka saya sarankan kita menggunakan jenis <span style="font-weight: bold;">Typical </span>saja. Untuk melanjutkan, silakan klik pada tombol <i>Next ></i></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><!--[if gte vml 1]><v:shape id="Picture_x0020_12" spid="_x0000_s1033" type="#_x0000_t75" style="'position:absolute;left:0;text-align:left;"> <v:imagedata src="file:///C:\DOCUME~1\VIKING\LOCALS~1\Temp\msohtml1\03\clip_image015.png" title=""> </v:shape><![endif]--><!--[if !vml]--><!--[endif]--><span style="font-size: 85%;" lang="IN"> 5.Setelah masuk pada halaman <b style="">Installing MySQL Server 5.0</b>, tunggulah proses installasi beberapa menit.<o:p></o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><span style=""> </span></span><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><br /></span></b></span></p><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-9.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /></div><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><br /></span></b></span></p><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><br /></span></b></span></p><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"> </span></b></span><span style="font-size: 85%;" lang="IN"><o:p></o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><!--[if gte vml 1]><v:shape id="Picture_x0020_25" spid="_x0000_s1034" type="#_x0000_t75" style="'position:absolute;left:0;text-align:left;"> <v:imagedata src="file:///C:\DOCUME~1\VIKING\LOCALS~1\Temp\msohtml1\03\clip_image017.png" title=""> </v:shape><![endif]--><!--[if !vml]--><!--[endif]--><span style="font-size: 85%;" lang="IN"> 6. </span><span style="font-size: 85%;">Tampilan berikutnya, informasi mengenai produk <b>MySQL Enterprise</b> (Anda harus membayar sejumlah uang untuk menggunakan produk berlisensi ini). Bila Anda berminat untuk menggunakan produk dengan lisensi ini, silakan kunjungi situsnya. Mari kita lanjutkan proses instalasi ini dengan menekan tombol <i>Next ></i></span> sebanyak dua kali.</p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" face="arial"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" face="arial"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" face="arial"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" face="arial"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" face="arial" style="text-align: center;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><o:p> </o:p></span></b></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><br /></span></b></span></p><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-10.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /></div><p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><br /></span></b></span></p><p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"><br /></span></b></span></p><p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><span style="font-size: 85%;"><b style=""><span style="" lang="IN"> </span></b></span><span style="font-size: 85%;" lang="IN"><o:p></o:p></span></p><span style="font-size: 85%;" lang="IN"><i style=""><o:p></o:p></i></span> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN">7. </span><span style="font-size: 85%;">Tunggu beberapa saat hingga proses instalasi selesai. Kemudian (sangat disarankan) untuk melanjutkan ke proses konfigurasi MySQL server (<i>Configure the MySQL Server now</i>). Dan Anda bisa menekan tombol <i>Finish </i>untuk tahapan ini (yang akan dilanjutkan dengan proses konfigurasi).</span></p><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-12.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /></div><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"> <span style="font-weight: bold;"></span><br /></span></p><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN">8. </span><span style="font-size: 85%;">Sudah siap untuk mengkonfigurasi MySQL server? Silakan klik pada tombol <i>Next</i>...</span></p><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-13.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /></div><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"> <span style="font-weight: bold;"></span><br /></span></p><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN">9. </span><span style="font-size: 85%;">Ada dua pilihan konfigurasi, <i>Detailed Configuration</i> dan <i>Standard Configuration</i>. Kita pilih saja <b>Standard Configuration</b>, karena mudah untuk diselesaikan. Klik pada tombol <i>Next ></i> untuk melanjutkan.</span></p><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><br /></span></p><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-14.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /></div><p class="MsoNormal" style="font-family: arial;"><br /></p><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN">10. </span><span style="font-size: 85%;">Tampilan berikutnya, disarankan untuk <b>mengaktifkan </b>pilihan <b>Install as Windows Service</b> dan juga <b>Launch the MySQL Server automatically</b> . Dengan pilihan ini maka setiap komputer Anda dinyalakan, secara otomatis program MySQL server akan dijalankan. Begitupun sebaiknya <b>aktifkan </b>pilihan <b>Include Bin directory in Windows Path</b>. Program-program MySQL biasanya disimpan di dalam directory <b>C:\Program Files\MySQL\MySQL Server 5.0\Bin</b>. Dengan mengaktifkan pilihan ini, maka Anda dapat menjalankan atau memanggil program MySQL langsung dari DOS/Command Prompt.</span></p><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-15.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /></div><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN">11. </span><span style="font-size: 85%;">tampilan berikutnya, mengenai sistem keamanan server MySQL. Sebaiknya Anda memberikan password khusus sebagai Root, dan tidak memberikan peluang kepada orang lain untuk memasuki sistem anda tanpa password. Maka <b>aktifkan </b>pilihan <i>Modify Security Setting</i> dan <b>masukkan password </b>Root Anda dengan seksama. Tetapi, <b>matikan </b>pilihan <b>Create An Anonymous Account</b>. Dengan demikian tidak sembarangan orang dapat masuk menggunakan MySQL server Anda.<br /> Satu hal lagi, disarankan <b>mematikan </b>pilihan <i>Enable Root access</i> <i>from remote machines</i>. Ini untuk mencegah celah-celah yang bisa dimasuki oleh orang-orang yang tidak bertanggungjawab menyelinap ke dalam sistem kita. Lanjutkan dengan menekan tombol <i>Next.</i></span></p><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><br /></span></p><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-16.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /></div><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><br /></span></p><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN">12. </span><span style="font-size: 85%;">bila Anda telah yakin untuk melanjutkan, klik pada tombol <i>Execute</i>. Dan Anda bisa santai sejenak sambil menunggu proses setting selesai.</span> </p><div align="center"><img src="http://www.arbiedesign.com/images/stories/tutorial/mysql-5.0.51/gambar-17.jpg" alt="Image" title="Image" width="378" border="0" height="290" hspace="6" /><p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN">13. </span>b<span style="font-size: 85%;">ila tidak ada kendala apapun, maka selesailah keseluruhan proses instalasi dan setting pada program MySQL 5.0.x ini. Selamat yach... Silakan klik pada tombol <i>Finish </i>untuk menuntaskan proses ini.</span></p></div><span style="font-size: 85%;" lang="IN"> </span> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="font-family: arial;"><span style="font-size: 85%;" lang="IN"><o:p> </o:p></span></p> <p class="MsoNormal" style="text-align: center; font-family: arial;" align="center"><img src="file:///D:/Unduhan/instalasi-software-database-mysql-t102.0_files/01-Welcome.gif" alt="" border="0" /></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2106055235885188791-2474239345474006225?l=fidianarashikamaru.blogspot.com' alt='' /></div>Nara Khahttp://www.blogger.com/profile/09079556578980931622noreply@blogger.com0tag:blogger.com,1999:blog-2106055235885188791.post-51285246699444413782009-09-02T18:49:00.000-07:002009-10-02T23:51:20.742-07:00<div style="text-align: justify;"><div style="text-align: center;"><span style="font-weight: bold; color: rgb(0, 0, 0); font-family: courier new;font-size:130%;" >Langkah-langkah membuat Slide baru, menyimpan File, mengatur Background, dan memberi efek Animasi</span><br /></div><div style="text-align: left; font-weight: bold; font-family: trebuchet ms;"><span style="font-size:100%;">Cara Menambah slide baru :<br /></span></div></div><ul style="text-align: left; font-weight: bold; font-family: trebuchet ms;"><li><span style="font-size:100%;"> Klik insert - pilih new slide.</span></li><li><span style="font-size:100%;"> Tekan tombol Ctrl+M.</span></li></ul><span style="font-family: trebuchet ms;font-size:100%;" ><span style="font-weight: bold;">Cara Menyimpan File Presentasi :</span><br /></span><ul style="text-align: left; font-weight: bold; font-family: trebuchet ms;"><li><span style="font-size:100%;"> Klik File - pilih save - tulis nama file - klik save</span></li><li><span style="font-size:100%;"> Tekan tombol Ctrl+S</span></li><li><span style="font-size:100%;"> Klik pada ikon disket</span></li></ul><span style="font-family: trebuchet ms;font-size:100%;" ><span style="font-weight: bold;">Cara mengubah Background :</span><br /></span><ul style="text-align: left; font-weight: bold; font-family: trebuchet ms;"><li><span style="font-size:100%;"> Klik Format - pilih Background - klik segitiga fulldown - atur background sesuai dengan selera - klik apply atau apply to all.<br /></span></li></ul><div style="text-align: left; font-weight: bold; font-family: trebuchet ms;"><span style="font-size:100%;">Cara memberi efek animasi :<br /> Klik Slideshow - pilih Custom Animation - atur sesuai dengan selera.</span></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/2106055235885188791-5128524669944441378?l=fidianarashikamaru.blogspot.com' alt='' /></div>Nara Khahttp://www.blogger.com/profile/09079556578980931622noreply@blogger.com0