tag:blogger.com,1999:blog-71288977252192197502024-09-04T17:34:18.382+07:00lnw108 รวบรวมเทคนิคคอมพิวเตอร์ต่างๆมาให้คุณkoobitorhttp://www.blogger.com/profile/01783496486390442441noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7128897725219219750.post-68511669802124319462011-01-18T01:03:00.002+07:002011-01-18T02:45:21.320+07:00การจะเชื่อมฐานข้อมูลกับ Netbean IDE ได้นั้นจำเป็นต้องมี Connecter เพื่อช่วยในการเชื่อมต่อ<br /> เรามาลองติดตั้งและใช้งานกันเลยดีกว่า<br /> <br /> ** ก่อนอื่นต้องติดตั้งโปรแกรมเหล่านี้ก่อนถึงจะทำตามได้<br /> 1.&nbsp;<span class="Apple-style-span" style="font-family: arial, helvetica, sans-serif; font-size: 14px;">Java SE Development Kit (JDK) ...กำลังเร่งทำบทความ</span><br /> 2. Netbeans IDE <span class="Apple-style-span" style="font-family: arial, helvetica, sans-serif; font-size: 14px;">...กำลังเร่งทำบทความ</span><br /> 3. MySQL <a href="http://lnw108.blogspot.com/2011/01/mysql-server.html">ติดตั้งตามนี้</a><br /> <br /> โหลด&nbsp;MySQL&nbsp;<span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; line-height: 23px;">Connector/J 5.1.14&nbsp;</span>กันก่อนเลย<br /> <span class="Apple-style-span" style="font-family: inherit;">Platform Independent , TAR Archive 5.1.14 3.1M &nbsp;<span class="Apple-style-span" style="color: #c5c5c5; font-size: 13px; line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=398132" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: white; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a></span><span class="Apple-style-span" style="color: #c5c5c5; font-size: 13px; line-height: 26px; white-space: nowrap;"><span class="Apple-style-span" style="color: #555555;">&nbsp;&nbsp;</span></span></span><span class="Apple-style-span" style="color: red; font-size: 13px; line-height: 26px; white-space: nowrap;">แนะนำตัวนี้สำหรับ Linux</span><br /> <span class="Apple-style-span" style="font-family: inherit;"><span class="Apple-style-span" style="line-height: 23px;">Platform Independent , ZIP Archive &nbsp;5.1.14 3.3M<span class="Apple-style-span" style="color: #555555;">&nbsp;</span><span class="Apple-style-span" style="color: #555555; font-size: xx-small;"> &nbsp;</span></span><span class="Apple-style-span" style="font-size: 13px; line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=398133" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: white; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a>&nbsp;&nbsp;</span><span class="Apple-style-span" style="color: red; font-size: 13px; line-height: 26px; white-space: nowrap;">แนะนำตัวนี้สำหรับ Windows</span></span><br /> <span class="Apple-style-span" style="line-height: 26px; white-space: nowrap;">โหลดมาจะได้ไฟร์ตามนี้นะครับ</span><br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipad4dcTqlWIaG1qg08HQlj2YSgYVTtDQk_TgdHH7q3cfz3EKlc0o31rYj_tjRhMz2p_RSOijn_TGLLvEkjP30h7zbnyDMFzQNeICf0TiTDH-sEAOlXQGvOnpqV90CrZp4Bha0r9We_Ww/s1600/mysql_connect_01.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipad4dcTqlWIaG1qg08HQlj2YSgYVTtDQk_TgdHH7q3cfz3EKlc0o31rYj_tjRhMz2p_RSOijn_TGLLvEkjP30h7zbnyDMFzQNeICf0TiTDH-sEAOlXQGvOnpqV90CrZp4Bha0r9We_Ww/s1600/mysql_connect_01.jpg" /></a><br /> <br /> ขั้นที่ 1 ไปที่&nbsp;C:\Program Files\Java\jdk1.6.0_22\ แตกไฟร์ที่โหลดมาลงในนี้ตามรูปเลย<br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0ZXUCR6N0_larbweYE5SqH6Ake6symYaZWPJsCwZHR-tqShbS3tQELU-XFLwJCtt6h7LE_6Vd991KhXXTQ2OdS4SOyB9s3YPnqmLsYDSR7fWmxp0tWGvAuqUzWBo8VjLZvlkbmjKMp00/s1600/mysql_connect_02.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0ZXUCR6N0_larbweYE5SqH6Ake6symYaZWPJsCwZHR-tqShbS3tQELU-XFLwJCtt6h7LE_6Vd991KhXXTQ2OdS4SOyB9s3YPnqmLsYDSR7fWmxp0tWGvAuqUzWBo8VjLZvlkbmjKMp00/s320/mysql_connect_02.jpg" width="153" /></a><br /> <br /> ขั้นที่ 2 คลิ๊กขวาที่&nbsp;mysql-connector-java-5.1.14-bin.jar แล้ว cut ไฟล์<br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB5nijtS1aQCKVWlPczFCdp8SPiE8VGRfPMMWd5cYUAY6z8qveIXQ-gxCHwmyVZsfzHuCFN_ZzAGTJvvuC_-Zz60T1oqgm6rqY6FTUcMiWT8rpt5Ma3QDEAE32SHbr32wQEMAl7flAUqk/s1600/mysql_connect_03.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="310" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB5nijtS1aQCKVWlPczFCdp8SPiE8VGRfPMMWd5cYUAY6z8qveIXQ-gxCHwmyVZsfzHuCFN_ZzAGTJvvuC_-Zz60T1oqgm6rqY6FTUcMiWT8rpt5Ma3QDEAE32SHbr32wQEMAl7flAUqk/s320/mysql_connect_03.jpg" width="320" /></a><br /> ขั้นที่ 3 นำไปว่างใน&nbsp;C:\Program Files\Java\jdk1.6.0_22\jre\lib\ext ตามภาพก่อนและหลัง<br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcggTGQhk1GvPB1bVrHj-CWq5yTziH39Ri173h_73me2bAguQAESLjVSygbtLG4mDN2wriGN_otowyUqL4ks4sXsO3i5xKK5ZPhrcrj3HUmHMVGLhrsEjNpStSTtw8ErYBxlR4ibzw8tA/s1600/mysql_connect_04.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="93" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcggTGQhk1GvPB1bVrHj-CWq5yTziH39Ri173h_73me2bAguQAESLjVSygbtLG4mDN2wriGN_otowyUqL4ks4sXsO3i5xKK5ZPhrcrj3HUmHMVGLhrsEjNpStSTtw8ErYBxlR4ibzw8tA/s320/mysql_connect_04.jpg" width="320" /></a><br /> <br /> ตอนนี้เราติดตั้ง&nbsp;MySQL&nbsp;<span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; line-height: 23px;">Connector/J เรียบร้อยแล้ว</span><br /> <br /> เพื่อนๆเปิด Netbeans ขึ้นมาเลยครับ เรากำลังจะลองเชื่อมต่อกันแล้ว<br /> ขั้นตอนที่ 1 ไปที่หน้าต่าง service =&gt; Database =&gt; Drivers =&gt; MySQL (Connector/J Driver)<br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiRcFi3p0SDZAkzVEoBgYu4GMS0lJi0cHM3aM07fWcEjaW_nkHwQGU6p7S8ySM1QTxYpzYAJyzRV6wTktstehuZppZuVI8vssALD_YfGt528vR9dNT6HFQ7s3Cnga9qvVqKk9g2n1gihw/s1600/mysql_connect_05.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="183" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiRcFi3p0SDZAkzVEoBgYu4GMS0lJi0cHM3aM07fWcEjaW_nkHwQGU6p7S8ySM1QTxYpzYAJyzRV6wTktstehuZppZuVI8vssALD_YfGt528vR9dNT6HFQ7s3Cnga9qvVqKk9g2n1gihw/s320/mysql_connect_05.jpg" width="320" /></a><br /> <br /> ขั้นตอนที่ 2 คลิ๊กขวา เลือก Connect Using...<br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDJMjRzsly8oNzIIwj37q4XDlRQM5Atz6rtRNx7xwuX0feGX8dtXuRwmZ4gr-BSfDi-r3LQ3NRTUAKV470I-5O4NxtgzL9m1tv_rcFl852yXnZ5YdlVi5lkC_p4y56YYTkv_tTDkJ1z-s/s1600/mysql_connect_06.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDJMjRzsly8oNzIIwj37q4XDlRQM5Atz6rtRNx7xwuX0feGX8dtXuRwmZ4gr-BSfDi-r3LQ3NRTUAKV470I-5O4NxtgzL9m1tv_rcFl852yXnZ5YdlVi5lkC_p4y56YYTkv_tTDkJ1z-s/s320/mysql_connect_06.jpg" width="320" /></a><br /> <br /> ขั้นตอนที่ 3 นี่เราจะมาเซตค่าการเชื่อมต่อกันนะครับ<br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaI_8PtYiMkeyTbTg-CCG_1XF6f5k_7LbGMBm26JlzF_ocHOv9Cap4RUzmQc9RsncyFCykgQbyffN6-nPQ9KRIZQmVomiTiLTTx2tK0ZfboL_gg0luv4tcS91pSnWM6OkrfXRmIAXb8sA/s1600/mysql_connect_07.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaI_8PtYiMkeyTbTg-CCG_1XF6f5k_7LbGMBm26JlzF_ocHOv9Cap4RUzmQc9RsncyFCykgQbyffN6-nPQ9KRIZQmVomiTiLTTx2tK0ZfboL_gg0luv4tcS91pSnWM6OkrfXRmIAXb8sA/s320/mysql_connect_07.jpg" width="320" /></a><br /> <br /> ขั้นตอนที่ 4 กด Finish แล้วกลับไปดูหน้าต่าง services จะได้ดังภาพนี้<br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbzyHi8cZ0dh_Q_B5AdAPdzjd2z7N82iE_qr4Rw33UkZIoKrwCIUG9HAVag5KLuf5UaXvLZn6j41LTsfFJgFbQarR5Azb7aOw4R9ERcFr3n5AdUWBZbUv8mHzAe3tTf_IFPjJoT6wbrc8/s1600/mysql_connect_08.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="231" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbzyHi8cZ0dh_Q_B5AdAPdzjd2z7N82iE_qr4Rw33UkZIoKrwCIUG9HAVag5KLuf5UaXvLZn6j41LTsfFJgFbQarR5Azb7aOw4R9ERcFr3n5AdUWBZbUv8mHzAe3tTf_IFPjJoT6wbrc8/s320/mysql_connect_08.jpg" width="320" /></a><br /> <br /> เป็นอันเสร็จสิ้นการเชื่อมต่อในบทนี้นะครับ<br /> <br /> ขั้นตอนต่อไปผมจะมาสอนการสร้างตารางลบตารางนะครับ<br /> ขอบคุณที่ติดตาม lnw108 นะครับkoobitorhttp://www.blogger.com/profile/01783496486390442441noreply@blogger.com0tag:blogger.com,1999:blog-7128897725219219750.post-86192450465961921202011-01-17T22:58:00.007+07:002011-01-18T02:16:14.510+07:00การติดตั้ง<span class="Apple-style-span" style="color: #666666;">&nbsp;</span><span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: 18px; font-weight: bold; line-height: 23px;">MySQL Workbench 5.2.31a (<span class="Apple-style-span" style="color: #666666; font-family: 'Times New Roman'; font-size: small; font-weight: normal; line-height: normal;">MySQL Administrator,MySQL GUI Tools</span>)</span><br /> <br /> <br /> <div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span class="Apple-style-span" style="color: #666666;">** จะต้องติดตั้ง MySQL Server ก่อน&nbsp;</span></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span class="Apple-style-span" style="color: #666666;">1.<a href="http://lnw108.blogspot.com/2011/01/mysql-server.html">วิธีติดตั้ง + สมัครสมาชิก MySQL&nbsp;</a></span></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span class="Apple-style-span" style="color: #666666;">2.<a href="http://lnw108.blogspot.com/2011/01/configuration-wizard-mysql-server.html">วิธีการ Config</a></span></div><div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><br /> </div><br /> เมื่อเราลง MySQL แล้วเรายังไม่สามารถจัดการฐานข้อมูลได้อย่างสะดวกสะบายนะครับ<br /> เราเลยจะมาติดตั้งโปรแกรมนี้กัน ไปโหลดกันเลยครับ <a href="http://dev.mysql.com/downloads/workbench/5.2.html">โหลดที่นี่เลย</a><br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2d54x4PIBz4m7ZAKJtJS_y_EHnXAaAGV9KfE9H39S5Wc3jdva8f6NaII8Ibq_i3-PJtCr9Z1ge353N0QzmI2yCIexMmvOYim3KJomagBmP6WUSWDmyd3BY4qZ0jTPtQM-Eq6NLj7qaRc/s1600/mysql_workbench_08.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2d54x4PIBz4m7ZAKJtJS_y_EHnXAaAGV9KfE9H39S5Wc3jdva8f6NaII8Ibq_i3-PJtCr9Z1ge353N0QzmI2yCIexMmvOYim3KJomagBmP6WUSWDmyd3BY4qZ0jTPtQM-Eq6NLj7qaRc/s320/mysql_workbench_08.jpg" width="320" /></a><br /> <br /> <br /> Workbench เป็นโปรแกรมจัดการฐานข้อมูลที่มีหน้าตาสวยงามแและมีความสามารถสูง<br /> ติดตั้งเพียงหนึ่งตัวแต่ได้มากกว่า 3 ระบบ<br /> 1.SQL Development<br /> 2.Data Modeling<br /> 3.Server Administration<br /> <span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: 13px; line-height: 23px;"></span><br /> <h1 style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-size: 18px; font-weight: bold; margin-bottom: 8px; margin-left: 0px; margin-right: 0px; margin-top: 15px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">MySQL Workbench 5.2.31a (<span class="Apple-style-span" style="color: #666666; font-family: 'Times New Roman'; font-size: small; font-weight: normal; line-height: normal;">MySQL Administrator,MySQL GUI Tools</span>)</h1><div><span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: x-small;"><span class="Apple-style-span" style="line-height: 23px;"><b>Windows (x86, 32-bit), MSI Installer 5.2.31a 25.9M</b>&nbsp;&nbsp;</span></span><span class="Apple-style-span" style="color: #c5c5c5; font-family: verdana, arial, helvetica, sans-serif; font-size: 13px; line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=398176" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: white; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a><span class="Apple-style-span" style="color: #555555;">&nbsp;&nbsp;</span><span class="Apple-style-span" style="color: red;">แนะนำตัวนี้สำหรับ 32 bit</span><span class="Apple-style-span" style="color: #555555;">&nbsp;</span></span><br /> <span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: x-small;"><span class="Apple-style-span" style="line-height: 23px;"><b>Windows (x86, 32-bit), ZIP Archive 5.2.31a 19.8M</b>&nbsp;&nbsp; &nbsp;</span></span><span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 13px; line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=398175" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: white; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a></span><br /> <span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: x-small;"><span class="Apple-style-span" style="line-height: 23px;"><b>Windows (x86, 32-bit), ZIP Archive 5.2.31a 28.3M</b>&nbsp;&nbsp; &nbsp;</span></span><span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: xx-small; line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=398177" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: white; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a></span><br /> <span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: x-small;"><b><br /> </b></span><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;">โหลดมาแล้วจะได้แบบนี้นะครับ</span><br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivzf8W_mLVd9N0DIMKDFY4uJm5BH0lYyr5GxibA6TLyt6HCZFvS6alcAklAh2XnQ9otq_jROFJZ9nqwD18lcfSgXusrMo98Q-aRMNowYbYapFqZ0HBmMWT3w4nYVSYBmTKI6fBze78mGg/s1600/mysql_workbench_01.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivzf8W_mLVd9N0DIMKDFY4uJm5BH0lYyr5GxibA6TLyt6HCZFvS6alcAklAh2XnQ9otq_jROFJZ9nqwD18lcfSgXusrMo98Q-aRMNowYbYapFqZ0HBmMWT3w4nYVSYBmTKI6fBze78mGg/s1600/mysql_workbench_01.jpg" /></a><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;"><br /> </span><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;">ขั้นที่ 1 คลิ๊ก Next ข้ามไปได้ครับ</span><br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc6gZHGpOV03O8_BOXxLCT_GRDxHF7e4FjIOMRe0mHgloEV5oy291cowSSVEIgA7acvipESdzb8TN1jmpBStmD7ekubw2UhtmcdkSbArPYfOcfDMKCaMH562FOsrczJub1qdZ8qt5qDs4/s1600/mysql_workbench_02.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc6gZHGpOV03O8_BOXxLCT_GRDxHF7e4FjIOMRe0mHgloEV5oy291cowSSVEIgA7acvipESdzb8TN1jmpBStmD7ekubw2UhtmcdkSbArPYfOcfDMKCaMH562FOsrczJub1qdZ8qt5qDs4/s320/mysql_workbench_02.jpg" width="320" /></a><br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc6gZHGpOV03O8_BOXxLCT_GRDxHF7e4FjIOMRe0mHgloEV5oy291cowSSVEIgA7acvipESdzb8TN1jmpBStmD7ekubw2UhtmcdkSbArPYfOcfDMKCaMH562FOsrczJub1qdZ8qt5qDs4/s1600/mysql_workbench_02.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"></a><br /> ขั้นที่ 2 เลือกตำแหน่งติดตั้งโปรแกรมครับ ไว้ที่เดิมเลยก็ได้ครับ Next<br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8hOnfBGjwdH10ZiD1cF9qc8YhBnlcBxwiVFHb3BZVntwB0lY_8GfUomjR1nZJxP8qjoitJg6-3vbrBcX01FFyuT26CahmiggHm5mlb3_oRdAecxZjOIEE5pFWT7za9cWKeHM-1S_bhJQ/s1600/mysql_workbench_03.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8hOnfBGjwdH10ZiD1cF9qc8YhBnlcBxwiVFHb3BZVntwB0lY_8GfUomjR1nZJxP8qjoitJg6-3vbrBcX01FFyuT26CahmiggHm5mlb3_oRdAecxZjOIEE5pFWT7za9cWKeHM-1S_bhJQ/s320/mysql_workbench_03.jpg" width="320" /></a><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;"><br /> </span><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;">ขั้นที่ 3 เลือกแบบ Complete ไปเลยครับ</span><br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2eiJcPVGZVSMDOa9xVSeV_QWSqsuBzmcX1a2Snxc1CRgroKHS3Q7WS8xhrktDqO7hqnf-sxiCpWyHt1HFr3dCkuKXgH9qD3GiJ6Q4ST_tFONFf0ZFWBAonL-6Ed_MButc-64YXuHXy8g/s1600/mysql_workbench_04.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2eiJcPVGZVSMDOa9xVSeV_QWSqsuBzmcX1a2Snxc1CRgroKHS3Q7WS8xhrktDqO7hqnf-sxiCpWyHt1HFr3dCkuKXgH9qD3GiJ6Q4ST_tFONFf0ZFWBAonL-6Ed_MButc-64YXuHXy8g/s320/mysql_workbench_04.jpg" width="320" /></a><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;"><br /> </span><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;">ขั้นที่ 4 แสดงค่าการติดตั้งพร้อมแล้ว install ได้เลย</span><br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjomBUUhl5CvVq3RypqmYZ6d5194yGhxXOI6u_z0CLEHYQtts2XEw6S-PKYPFhkLXDG20_rWXoYujehmzh-oRN3K3CzMdIDB2HZLNhLKLJ4FNgN_rMomXovlRJPPEddLWIZDgcv7ZxWuf8/s1600/mysql_workbench_05.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjomBUUhl5CvVq3RypqmYZ6d5194yGhxXOI6u_z0CLEHYQtts2XEw6S-PKYPFhkLXDG20_rWXoYujehmzh-oRN3K3CzMdIDB2HZLNhLKLJ4FNgN_rMomXovlRJPPEddLWIZDgcv7ZxWuf8/s320/mysql_workbench_05.jpg" width="320" /></a><br /> <br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;">ขั้นที่ 5 รอๆ</span><br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZZtG_l-CWfHxfekMyl7H4oXrvxUK2wENqbvwj1IdhJk5Hf4nDuFoBZ4AgH3JlBXiuODh7YduUDfop0IW1bhHdUNz0BSTDm7_YM3N6HkWEFs8CAHfEX68mqsVKIq2mqbp-QiqSUDkiq6Q/s1600/mysql_workbench_06.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZZtG_l-CWfHxfekMyl7H4oXrvxUK2wENqbvwj1IdhJk5Hf4nDuFoBZ4AgH3JlBXiuODh7YduUDfop0IW1bhHdUNz0BSTDm7_YM3N6HkWEFs8CAHfEX68mqsVKIq2mqbp-QiqSUDkiq6Q/s320/mysql_workbench_06.jpg" width="320" /></a><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;"><br /> </span><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;">ขั้นที่ 6 Finish แล้วโปรแกรมก็เปิดขึ้นมาดังรูปครับ</span><br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7fDu9tPoEQ1UWs0zE0ncpPEsaSdWKlh4kt48padmUhppojHmX2lhKQOI90ntCLE5luvXnYUkyGJCvlvXNVu6_e-BeioHGHQ98_X82Xea32EtLDYABsGT3gFknPIeqB_9UL1vLsfL1mkE/s1600/mysql_workbench_07.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7fDu9tPoEQ1UWs0zE0ncpPEsaSdWKlh4kt48padmUhppojHmX2lhKQOI90ntCLE5luvXnYUkyGJCvlvXNVu6_e-BeioHGHQ98_X82Xea32EtLDYABsGT3gFknPIeqB_9UL1vLsfL1mkE/s320/mysql_workbench_07.jpg" width="320" /></a><br /> <br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiLYALNvE71VnVB2VbI_XAmkN0fbpCOWDMB3OkDFI9XouuuioTZ2snADKpOVGLlfJCR2L6GXosIQXsdTqmfp2dwg51Gqm5cMiOxPcv0DOTqJpxwiWfAsZmQn981IBvozEjI3yUzElLhYQ/s1600/mysql_workbench_09.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="172" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiLYALNvE71VnVB2VbI_XAmkN0fbpCOWDMB3OkDFI9XouuuioTZ2snADKpOVGLlfJCR2L6GXosIQXsdTqmfp2dwg51Gqm5cMiOxPcv0DOTqJpxwiWfAsZmQn981IBvozEjI3yUzElLhYQ/s320/mysql_workbench_09.jpg" width="320" /></a></div><div><span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif;"><b>ติดตามตอนต่อไปเป็นการใช่งาน<span class="Apple-style-span" style="color: #555555;">&nbsp;</span></b></span><span class="Apple-style-span" style="font-weight: bold;">MySQL Workbench ขอบคุณมากที่ติดตามนะครับ&nbsp;</span><br /> <span class="Apple-style-span" style="font-weight: bold;">มีข้อสงสัยถามได้เลยนะครับ</span></div>koobitorhttp://www.blogger.com/profile/01783496486390442441noreply@blogger.com2tag:blogger.com,1999:blog-7128897725219219750.post-137836970991350282011-01-17T21:51:00.010+07:002011-01-18T02:11:58.781+07:00หลังจากที่เราติดตั้ง MySQL Server กันเป็นที่เรียบร้อยแล้ว<br /> เรามาตั้งค่าให้กับมันกันเลยดีกว่านะครับ<br /> <br /> <br /> <div style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;"><span class="Apple-style-span" style="color: #666666;">** จะต้องติดตั้ง MySQL Server ก่อน&nbsp;</span><span class="Apple-style-span" style="color: #666666;"><a href="http://lnw108.blogspot.com/2011/01/mysql-server.html">วิธีติดตั้ง + สมัครสมาชิก MySQL&nbsp;</a></span></div><br /> <br /> ขั้นที่ 1 Next ผ่านไป<br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5pDvjrkvZNk-aZMXcgtnmcjnF4UCMbH64aA_1dX0oAaHda3phKPlj-XXzAcUYfY-6C-CQKUFaqd6A7f1y7QHHRBpqnkyQUBObM2oWnR8mPb8hfpbBrBF2NbtfIV80IZmCstU44Cw14gc/s1600/mysql_config_01.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5pDvjrkvZNk-aZMXcgtnmcjnF4UCMbH64aA_1dX0oAaHda3phKPlj-XXzAcUYfY-6C-CQKUFaqd6A7f1y7QHHRBpqnkyQUBObM2oWnR8mPb8hfpbBrBF2NbtfIV80IZmCstU44Cw14gc/s320/mysql_config_01.jpg" width="320" /></a><br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> ขั้นที่ 2 เลือก Standard Configuration ง่ายดี<br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkRt-Yi9ESKSc37_-9oBr63WurfZ6uYhwsMOW_HxcrvxvtETqNTSMVsygtOFzQ-igsaP_TWr2Ue-Vx3x2GfNTEwWB3ycY8LPNgT6FdOMJg6qgmphZfcfeFXaPQkvWETLkBkGkgOi9FLl8/s1600/mysql_config_02.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="245" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkRt-Yi9ESKSc37_-9oBr63WurfZ6uYhwsMOW_HxcrvxvtETqNTSMVsygtOFzQ-igsaP_TWr2Ue-Vx3x2GfNTEwWB3ycY8LPNgT6FdOMJg6qgmphZfcfeFXaPQkvWETLkBkGkgOi9FLl8/s320/mysql_config_02.jpg" width="320" /></a><br /> <br /> ขั้นที่ 3 ให้ติีกค่า Include Bin Directory in Windows PATH ด้วย<br /> เพื่อให้ใช่งานผ่าน Command Lind ได้ด้วยนะครับ<br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHQjRmIqeMgpdoma2o3rpiS6Srm-5dbP2lAr8GUrAz1BwAc7ym4q1UDrwRJwVGHuYpFY-UeFY2NY0P7IHKmu8Sy91U2cd_uvKnQ8Dka0DhYydt2hc5eGCY1ZD4PuIWS7c08JQbGCxTajs/s1600/mysql_config_03.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHQjRmIqeMgpdoma2o3rpiS6Srm-5dbP2lAr8GUrAz1BwAc7ym4q1UDrwRJwVGHuYpFY-UeFY2NY0P7IHKmu8Sy91U2cd_uvKnQ8Dka0DhYydt2hc5eGCY1ZD4PuIWS7c08JQbGCxTajs/s320/mysql_config_03.jpg" width="320" /></a><br /> <br /> ขั้นที่ 4 ตั้ง password ให้กับ root ของเรา<br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBwv65Rh8rk3SjqCBkj8ZsihKPCRqH9XdUKXwuZBFMPbL7rajyPMS7Wb_e_YKpbUEMCqnUiFX5jHB3Nc4VJewtiTF42EB2Eg5vpdH1kJu08x8PtK9WdDC8lOsTICAWZnI2N5Ab-IFn6ew/s1600/mysql_config_04.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBwv65Rh8rk3SjqCBkj8ZsihKPCRqH9XdUKXwuZBFMPbL7rajyPMS7Wb_e_YKpbUEMCqnUiFX5jHB3Nc4VJewtiTF42EB2Eg5vpdH1kJu08x8PtK9WdDC8lOsTICAWZnI2N5Ab-IFn6ew/s320/mysql_config_04.jpg" width="320" /></a><br /> <br /> ขั้นที่ 5 กด Execute เลย<br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuxmU_Mf5E94rpxOve599JwtRHKH2qWm_8DB514faDFvlDWWnJZOFH8WPxAQikzi2kSlLHaVdQCLPKlOKNjnLggnecscUrlgnU5YTDBY8F3lkSx7MFOX-y33jtH6-0eOgVBqc33tEh958/s1600/mysql_config_05.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuxmU_Mf5E94rpxOve599JwtRHKH2qWm_8DB514faDFvlDWWnJZOFH8WPxAQikzi2kSlLHaVdQCLPKlOKNjnLggnecscUrlgnU5YTDBY8F3lkSx7MFOX-y33jtH6-0eOgVBqc33tEh958/s320/mysql_config_05.jpg" width="320" /></a><br /> <br /> ขั้นที่ 6 กด Finish เป็นอันเรียบร้อย<br /> <br /> ถ้าอยากใช่งานอย่างเต็มประสิทธิภาพ ไปติดตั้ง GUI Tools กันต่อเลย <a href="http://lnw108.blogspot.com/2011/01/mysql-administrator-mysql-gui-tools.html">ที่นี่</a>koobitorhttp://www.blogger.com/profile/01783496486390442441noreply@blogger.com1tag:blogger.com,1999:blog-7128897725219219750.post-84639225474523419702011-01-17T21:12:00.008+07:002011-01-18T02:11:42.982+07:00การติดตั้ง <span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: 18px; font-weight: bold; line-height: 23px;">MySQL Community Server 5.5.8 </span><span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 18px; font-weight: bold; line-height: 23px;">ไม่ใช่เรื่องยากอีกต่อไป</span><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 18px; font-weight: bold; line-height: 23px;"><br /> </span><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 18px; line-height: 23px;">ก่อนอื่นต้องเข้าไปโหลดตัวติดตั้ง <a href="http://dev.mysql.com/downloads/mysql/">โหลดได้ที่นี่เลย</a></span><br /> <br /> <a href="http://www.mysql.com/common/logos/logo-mysql-110x57.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://www.mysql.com/common/logos/logo-mysql-110x57.png" /></a>ตัวติดตั้งแบ่งได้เป็นสองแบบ คือ แบบ MSI กับ แบบ ZIP<br /> (ควรโหลดแบบ MSI เพราะจะเหมือนกานติดตั้งเกมส์หรือโปรแกรมทั่วไปบน windows นะครับ)<br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 13px;"><b style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #555555; font-size: 13px; line-height: 23px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"><br /> </b></span><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 13px;"><b style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #555555; font-size: 13px; line-height: 23px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">Windows (x86, 32-bit), MSI Installer</b><span class="Apple-style-span" style="line-height: 23px;"><span class="Apple-style-span" style="color: #555555;">5.5.8 120.6M &nbsp;</span><span class="Apple-style-span" style="line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=399405" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; border-bottom-color: rgb(48, 76, 96); border-bottom-style: solid; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-style: solid; border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: white; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a><span class="Apple-style-span" style="color: #555555;">&nbsp;&nbsp;</span><span class="Apple-style-span" style="color: red;">แนะนำตัวนี้สำหรับ 32 bit</span><span class="Apple-style-span" style="color: #555555;">&nbsp;</span></span></span></span><br /> <span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: x-small;"><span class="Apple-style-span" style="line-height: 26px; white-space: nowrap;"><span class="Apple-style-span" style="font-size: 13px; line-height: 23px; white-space: normal;"><b style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #555555; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">Windows (x86, 64-bit), MSI Installer</b><span class="Apple-style-span" style="color: #555555;">5.5.8 122.7M &nbsp;</span><span class="Apple-style-span" style="line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=399431" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; border-bottom-color: rgb(48, 76, 96); border-bottom-style: solid; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-style: solid; border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: white; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a><span class="Apple-style-span" style="color: #555555;">&nbsp;&nbsp;</span><span class="Apple-style-span" style="color: red;">แนะนำตัวนี้สำหรับ 64 bit</span></span><br /> <b style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: #555555; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">Windows (x86, 32-bit), ZIP Archive</b><span class="Apple-style-span" style="color: #555555;">5.5.8 &nbsp; 27.5M &nbsp;&nbsp;</span></span></span></span><span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: x-small; line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=399301" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; border-bottom-color: rgb(48, 76, 96); border-bottom-style: solid; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-style: solid; border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: white; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a></span><br /> <span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: x-small;"><b style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">Windows (x86, 32-bit), ZIP Archive</b>5.5.8 &nbsp; 132.5M &nbsp;&nbsp;<span class="Apple-style-span" style="font-size: 13px; line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=399430" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; border-bottom-color: rgb(48, 76, 96); border-bottom-style: solid; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-style: solid; border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: #ffcc66; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a></span><br /> <b style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; border-bottom-width: 0px; border-color: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-size: 13px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;">Windows (x86, 64-bit), ZIP Archive</b>5.5.8 &nbsp; 134.7M &nbsp;&nbsp;<span class="Apple-style-span" style="font-size: 13px; line-height: 26px; white-space: nowrap;"><a href="http://dev.mysql.com/downloads/mirror.php?id=399432" style="background-attachment: initial; background-clip: initial; background-color: #217ba8; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; border-bottom-color: rgb(48, 76, 96); border-bottom-style: solid; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(224, 224, 224); border-left-style: solid; border-left-width: 1px; border-right-color: rgb(48, 76, 96); border-right-style: solid; border-right-width: 1px; border-style: initial; border-top-color: rgb(224, 224, 224); border-top-style: solid; border-top-width: 1px; color: white; font-size: 12px; font-weight: bold; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: initial; outline-style: initial; outline-width: 0px; padding-bottom: 3px; padding-left: 8px; padding-right: 8px; padding-top: 3px; text-decoration: none; vertical-align: baseline;">Download</a></span></span><br /> <div><br /> </div><div>* การโหลดจะต้องสมัครสมาชิกกับทาง MySQL ก่อนนะครับ</div><div>ขั้นที่ 1 กดสมัครสมาชิกเลย</div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCniiuyytF6SLFgDqHhAY75YDN936HXRS1J4HpWT1R_DCjuOMWkhaHUDqvyPSUF16V_4NLRFU8ipcK0nh2GLQnPHKiRksWR4IuFuvcX-t0z5gGyp9cH9YOOCAoSoPiaO8QaAtLE8epIVs/s1600/mysql_regis_01.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCniiuyytF6SLFgDqHhAY75YDN936HXRS1J4HpWT1R_DCjuOMWkhaHUDqvyPSUF16V_4NLRFU8ipcK0nh2GLQnPHKiRksWR4IuFuvcX-t0z5gGyp9cH9YOOCAoSoPiaO8QaAtLE8epIVs/s320/mysql_regis_01.jpg" width="320" /></a></div><div>ขั้นที่ 2 กรอกข้อมูลกันดีกว่า ตามรูปได้เลยครับ</div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCniiuyytF6SLFgDqHhAY75YDN936HXRS1J4HpWT1R_DCjuOMWkhaHUDqvyPSUF16V_4NLRFU8ipcK0nh2GLQnPHKiRksWR4IuFuvcX-t0z5gGyp9cH9YOOCAoSoPiaO8QaAtLE8epIVs/s1600/mysql_regis_01.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7aqUtC8Lak6gHvxpjzJxSHVPXtS8QxN6ibW1jzzESFh1yzmx1N6ymqDy50vntZ8S1B3frKGPSvrA0r4C3VUcCBHd617OSO7ti6V71CncQGxt3NGqgkhGlfLbeBOvuDxYDhHhSC4uVd2A/s1600/mysql_regis_02.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7aqUtC8Lak6gHvxpjzJxSHVPXtS8QxN6ibW1jzzESFh1yzmx1N6ymqDy50vntZ8S1B3frKGPSvrA0r4C3VUcCBHd617OSO7ti6V71CncQGxt3NGqgkhGlfLbeBOvuDxYDhHhSC4uVd2A/s320/mysql_regis_02.jpg" width="259" /></a></div><div>ขั้นที่ 3 ไปที่เมล์เพื่อเอารหัสผ่านมา Login นะครับ<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXNdkKVHDSdH5i1YIryuP9LOB5RIRJVXgCkCq7tZl7iecZE4nNwzysYs8NIwZDuUklxcjwkRSozms4GqKWliYUiRbE4YnXSf6iZzrVCrf45td8ESteSwdwjKD0SwhclURNez8eFFtmZf8/s1600/mysql_regis_04.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXNdkKVHDSdH5i1YIryuP9LOB5RIRJVXgCkCq7tZl7iecZE4nNwzysYs8NIwZDuUklxcjwkRSozms4GqKWliYUiRbE4YnXSf6iZzrVCrf45td8ESteSwdwjKD0SwhclURNez8eFFtmZf8/s320/mysql_regis_04.jpg" width="320" /></a></div><div><br /> </div><div>ขั้นที่ 4 เข้าระบบแล้วกลับไปกดโหลดโปรแกรมที่เลือกไว้</div><div><br /> </div><div>โหลดมาเสร็จจะได้ไฟล์ดังรูป</div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikmgopZsyCngZz8SOy3N-l8BBxmdJtJIhWvZ2jXCTyrOHeYABj-JYGBzqR88qZ1Rq-cbt0MgCEm6vmffxilE2zmK-B1u8Hd_LHM6G3K9Gih1ZfbcWeOrDWn8mRHqm4g7vHtvHDcQrRYBM/s1600/mysql_regis_03.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikmgopZsyCngZz8SOy3N-l8BBxmdJtJIhWvZ2jXCTyrOHeYABj-JYGBzqR88qZ1Rq-cbt0MgCEm6vmffxilE2zmK-B1u8Hd_LHM6G3K9Gih1ZfbcWeOrDWn8mRHqm4g7vHtvHDcQrRYBM/s1600/mysql_regis_03.jpg" /></a><br /> ขั้นที่ 1 เปิดตัวติดตั้งได้หน้าตาแบบนี้ครับ คลิ้ก Next<br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiufNucjIOJsWKdwzH1zlrdXHILjxDk_MtdsQZeke6HAc1n7bfh7Hmv7hfnhScWtVUhj_b11AOWShSB_Doh2TDU_pfkbkXmaG-M-IPfEvJ75Lv34ktpHc46BAUGVC9ehIUCMpUmJF-cLuU/s1600/mysql_regis_05.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="254" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiufNucjIOJsWKdwzH1zlrdXHILjxDk_MtdsQZeke6HAc1n7bfh7Hmv7hfnhScWtVUhj_b11AOWShSB_Doh2TDU_pfkbkXmaG-M-IPfEvJ75Lv34ktpHc46BAUGVC9ehIUCMpUmJF-cLuU/s320/mysql_regis_05.jpg" width="320" /></a><br /> <br /> </div><div>ขั้นที่ 2 ยอมรับข้อตกลงในการใช่งาน<br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja_KeXd3Ahy1dV99nb4RKxM4qCw4t9y-yO4dIwBgKorgLsduEcptRBm8PgfLaL1_0hODTYa9ukQH3W8CBCcpHPr9zM9wSn1inN3qV5Pl4o44WuuEVBCyse_sVhM4xQ2cIFVk6buNczAyM/s1600/mysql_regis_06.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja_KeXd3Ahy1dV99nb4RKxM4qCw4t9y-yO4dIwBgKorgLsduEcptRBm8PgfLaL1_0hODTYa9ukQH3W8CBCcpHPr9zM9wSn1inN3qV5Pl4o44WuuEVBCyse_sVhM4xQ2cIFVk6buNczAyM/s320/mysql_regis_06.jpg" width="320" /></a><br /> <br /> ขั้นที่ 3 เลือก Typical สำหรับการติดตั้งแบบพื้นฐาน(<span class="Apple-style-span" style="color: red;">แนะนำTypical</span>) Complete สำหรับติดตั้งทุกอย่างลงบนเครื่อง<br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbco6EIl22MpKboMV0vnmDEEAhPOFOCcrt1BbTz_Q4Et3avRfKCFGI0CQEblH1Hj2mnhsvAPkZPFLluOq-ZDYUQSMPxGFR4AwXdhi3hKdAPNkFOq9JCKaMsnlueV1jeZakmknq0BhbonQ/s1600/mysql_regis_07.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="255" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbco6EIl22MpKboMV0vnmDEEAhPOFOCcrt1BbTz_Q4Et3avRfKCFGI0CQEblH1Hj2mnhsvAPkZPFLluOq-ZDYUQSMPxGFR4AwXdhi3hKdAPNkFOq9JCKaMsnlueV1jeZakmknq0BhbonQ/s320/mysql_regis_07.jpg" width="320" /></a><br /> <br /> ขั้นที่ 4 install เลย<br /> <br /> <span class="Apple-style-span" style="-webkit-text-decorations-in-effect: none; clear: left; color: black; display: inline !important; margin-bottom: 1em; margin-right: 1em;"></span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzR3dXlT1qH4-PsKk2f3vBJLdKwJxaLUlw6hkCF0ZrvQdMozTeR5nNwcJPqnFiBn1Cz6hE7lwILR0ReFePEQVZCHn10k9lUKxoXAblS5r4K2i78-5EuYi8qZs6MrbqQANAsDj-HeKtNKk/s1600/mysql_regis_08.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="249" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzR3dXlT1qH4-PsKk2f3vBJLdKwJxaLUlw6hkCF0ZrvQdMozTeR5nNwcJPqnFiBn1Cz6hE7lwILR0ReFePEQVZCHn10k9lUKxoXAblS5r4K2i78-5EuYi8qZs6MrbqQANAsDj-HeKtNKk/s320/mysql_regis_08.jpg" width="320" /></a><br /> <br /> รอติดตั้ง ในระหว่างรอจะมีหน้าแนะนำ MySQL สำหรับองค์กรใหญ่ ให้คลิ๊ก Next ผ่านไป<br /> <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJ2QaU_TPHoJr_haC9ISEoMJvr2BttsPjjRXwPptY3Gr8bg3jfL9NKLs9tGhFunvaNpH62v5MzaF0ixBS1XZj6jsb-rTMsk4SFQVVqcwKzHvRJO3ec8HOuFxTLVQYSFSi04FbKR8dqgV0/s1600/mysql_regis_11.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span class="Apple-style-span" style="color: black;"><br /> </span></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJ2QaU_TPHoJr_haC9ISEoMJvr2BttsPjjRXwPptY3Gr8bg3jfL9NKLs9tGhFunvaNpH62v5MzaF0ixBS1XZj6jsb-rTMsk4SFQVVqcwKzHvRJO3ec8HOuFxTLVQYSFSi04FbKR8dqgV0/s1600/mysql_regis_11.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span class="Apple-style-span" style="color: black;"><img border="0" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJ2QaU_TPHoJr_haC9ISEoMJvr2BttsPjjRXwPptY3Gr8bg3jfL9NKLs9tGhFunvaNpH62v5MzaF0ixBS1XZj6jsb-rTMsk4SFQVVqcwKzHvRJO3ec8HOuFxTLVQYSFSi04FbKR8dqgV0/s320/mysql_regis_11.jpg" width="320" /></span></a></div><br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> คลิ๊ก Finish จบการติดตั้ง<br /> <div class="separator" style="clear: both; text-align: center;"><br /> </div>&nbsp;<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpNRQRoNKZLc2mgmEzJMn_KiAguT-gPz6kmNeVV17Kx2GKw2REEmFF-gyk9-3xIQ32w8tG6ejoFIAW3rxT_vMiym4G50ve_Q570CEPHskyimtUShS4tdCso9dQlw5L3PEYYynkGHg0Cgc/s1600/mysql_regis_10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="251" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpNRQRoNKZLc2mgmEzJMn_KiAguT-gPz6kmNeVV17Kx2GKw2REEmFF-gyk9-3xIQ32w8tG6ejoFIAW3rxT_vMiym4G50ve_Q570CEPHskyimtUShS4tdCso9dQlw5L3PEYYynkGHg0Cgc/s320/mysql_regis_10.jpg" width="320" /></a><br /> <br /> แต่ยังไม่หมดเพียงแค่นี่ มา config กันก่อนใช่งาน <a href="http://lnw108.blogspot.com/2011/01/configuration-wizard-mysql-server.html">ไปที่นี่เลยยย</a><br /> <br /> <br /> </div><span class="Apple-style-span" style="color: #555555; font-family: verdana, arial, helvetica, sans-serif; font-size: 13px; line-height: 23px;"></span>koobitorhttp://www.blogger.com/profile/01783496486390442441noreply@blogger.com1