Mengkoneksikan Database MySql di Delphi

<br /><div style="text-align: center;"><img src="http://www.blog.riauhost.net/wp-content/uploads/2015/01/mysql_backup.png" /></div><br /><div style="text-align: justify;"><b>Jellykom | Mengkoneksikan Database MySql di Delphi - </b>Dalam dunia programming, penggunaan database merupakan suatu hal pokok yang tak bisa dipisahkan, tak terkecuali Delphi. Penggunaan database bisa mempermudah programmer untuk menyimpan data-data penting dengan aman dan mudah. Salah satu Data Base Management System (DBMS) yang sering digunakan yaitu MySql.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">Dibawah ini adalah langkah-langkah yang digunakan untuk mengkoneksikan database MySql dengan Borland Delphi 7. Terdapat 3 tahapan pertama, yaitu membuat database MySql, tahapan kedua mengkonfigurasi ODBC Connector, tahap ketiga menghubungkan ODBC Connector ke Form Delphi. Untuk softwarenya, silahkan unduh dibawah ini:</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">Database MySQL (Pilih Satu): <b>[<a href="http://dev.mysql.com/downloads/windows/installer/" target="_blank">Download MySQL</a>] </b><b>[<a href="https://www.apachefriends.org/xampp-files/5.6.3/xampp-win32-5.6.3-0-VC11-installer.exe" target="_blank">Download Xampp</a>] </b><b>[<a href="http://sourceforge.net/projects/wampserver/files/WampServer%202/Wampserver%202.5/wampserver2.5-Apache-2.4.9-Mysql-5.6.17-php5.5.12-32b.exe/download" target="_blank">Download Wamp</a>]</b></div><br /><br />ODBC Connector <b>[<a href="http://dev.mysql.com/downloads/connector/odbc/" target="_blank">Download ODBC Connector</a>]</b><br /><div><div><b><br /></b></div><div><b><br /></b></div><div><b>Tahap 1, Membuat Database MySQL</b></div></div><br />1. Buat sebuah database MySQL, misalnya "belajar"<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHd7EGiU-0d20ceFnGYKOZORfSzOt72UoPcfxLCyWY1GxTaAtwxQmaTXs1oYNO_F9Ip_nA3Pr5V1AaY-UxII7Z3lH0yiWCJSaaOGbLpff8bCm1jw2NmTOcilMTBIOATise7L5qZpQhLWU/s1600/2015-04-10_181625.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="" border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHd7EGiU-0d20ceFnGYKOZORfSzOt72UoPcfxLCyWY1GxTaAtwxQmaTXs1oYNO_F9Ip_nA3Pr5V1AaY-UxII7Z3lH0yiWCJSaaOGbLpff8bCm1jw2NmTOcilMTBIOATise7L5qZpQhLWU/s1600/2015-04-10_181625.png" title="jellykom" width="320" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div> 2. Buat Tabel dan field yang sobat inginkan, lalu tentukan masing-masing fieldnya<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2Mig2Qh4GJgM-mc_QQ5EbDjEpF6YNItToMB3LbgJf6yfnyXDcwZo5DhUChor-ImzdwqoRDLMAIza49O4beJcbxMsG8sZ0AvYHPCpBUGcdbAzjqQTBQa5hbUrGv58C7pVHXHTsJ_iPM2w/s1600/2015-04-10_181830.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="126" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2Mig2Qh4GJgM-mc_QQ5EbDjEpF6YNItToMB3LbgJf6yfnyXDcwZo5DhUChor-ImzdwqoRDLMAIza49O4beJcbxMsG8sZ0AvYHPCpBUGcdbAzjqQTBQa5hbUrGv58C7pVHXHTsJ_iPM2w/s1600/2015-04-10_181830.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKEozxl31ENJJNhqjOZCd3UfNSjuaoaB3NYYWZXzMKwQLCWRSDTfadNNjKYKeQ__n-1-vZJVHeIydCGKUUpNFFgE6aFrbDaWkCNG96QwXZcFKJfPcVTJusoceIR3lNU60X-0Izjevh-OU/s1600/2015-04-10_182102.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="183" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKEozxl31ENJJNhqjOZCd3UfNSjuaoaB3NYYWZXzMKwQLCWRSDTfadNNjKYKeQ__n-1-vZJVHeIydCGKUUpNFFgE6aFrbDaWkCNG96QwXZcFKJfPcVTJusoceIR3lNU60X-0Izjevh-OU/s1600/2015-04-10_182102.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;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><b>Tahap 2, Mengkoneksikan database MySQL Pada ODBC Connector</b><br /><b><br /></b>1. Aktifkan ODBC Connector melalui Run Program (Win+R), lalu ketikan "ODBCAD32"<br />  <br /><div class="separator" style="clear: both; text-align: center;"></div><div style="text-align: justify;">2. Setelah muncul jendela ODBC Data Source Administrator, buat Data Source Baru dengan                   mengklik "<b>ADD</b>", lalu pilih <b>MySQL ODBC ANSI Driver</b></div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNr4of4Eg9cs-JApDzrteBCcIBmr5qqYHkBX1Mtp3xvQBVX9kvnJfrxjmjfUK8nVLwg2c2Via6FoxzE_ZohOE5cOmxudrPhvImmgxsXaUj83Y85P-g1f9gTgkUxWm9Hn1I4uzMiWV3xnQ/s1600/2015-04-10_183255.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="264" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNr4of4Eg9cs-JApDzrteBCcIBmr5qqYHkBX1Mtp3xvQBVX9kvnJfrxjmjfUK8nVLwg2c2Via6FoxzE_ZohOE5cOmxudrPhvImmgxsXaUj83Y85P-g1f9gTgkUxWm9Hn1I4uzMiWV3xnQ/s1600/2015-04-10_183255.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgu0bhOIKpxkn5zW39f6H5lAZaG2tGbygCaOkt7CdI5dofpDxyBmlqe40CcGkl54YdBH_tn7SH3C4jm5mHAkEESBXOqt_pNBezalOu2wZQ6ramyDc043nEHpnaAKWjcasb94SH7qXFPmpA/s1600/2015-04-10_183310.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgu0bhOIKpxkn5zW39f6H5lAZaG2tGbygCaOkt7CdI5dofpDxyBmlqe40CcGkl54YdBH_tn7SH3C4jm5mHAkEESBXOqt_pNBezalOu2wZQ6ramyDc043nEHpnaAKWjcasb94SH7qXFPmpA/s1600/2015-04-10_183310.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: justify;">3. Isikan konfigurasinya seperti pada gamber dibawah ini. Pada bagian "User", isikan user yang sobat gunakan pada user MySQL. Bila belum pernah mengubahnya, maka gunakan "<b>root</b>" dan kosongkan password. Tekan "Test" untuk menguji apakah database sudah terhubung.</div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifyZbypBYqPPAOMxhE50gx2rnk0ouoxAqP2hvwRrM-4MTqgU5Q_3NsSKgpiROQZXZfOtuuzyzeoKksrzTOGApBzSH-AexdwItnmbpoiaoGkeRCWPm9p3J2K3MjrjBHaCcO9ynrgD9EUPE/s1600/2015-04-10_183411.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="306" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifyZbypBYqPPAOMxhE50gx2rnk0ouoxAqP2hvwRrM-4MTqgU5Q_3NsSKgpiROQZXZfOtuuzyzeoKksrzTOGApBzSH-AexdwItnmbpoiaoGkeRCWPm9p3J2K3MjrjBHaCcO9ynrgD9EUPE/s1600/2015-04-10_183411.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: justify;"><b>Tahap 3, Menghubungkan MySQL ke form delphi</b></div><div class="separator" style="clear: both; text-align: justify;"><b><br /></b></div><div class="separator" style="clear: both; text-align: justify;">1. Buat sebuah form pada delphi. Lalu masukan juga komponen-komponen berikut</div><div class="separator" style="clear: both; text-align: justify;"></div><ul><li>ADO Connecion1</li><li>ADO Query1</li><li>Data Source1</li><li>DBGrid1</li></ul><div class="separator" style="clear: both; text-align: justify;"><br /></div><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVR-tNrcS4U0UDYFwHRnyxp4cjBUiJa6Hk4G5xBDOE2zuaCxfMqBphlSLGK5LW-9JQDo_J-MZ-jOqsn9dLnsb9iq7uTJAMboP6csLyTcbQSjRH9xTslkovrgJVQ_mufgBMZPWz6nPVCds/s1600/2015-04-10_182748.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="" border="0" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVR-tNrcS4U0UDYFwHRnyxp4cjBUiJa6Hk4G5xBDOE2zuaCxfMqBphlSLGK5LW-9JQDo_J-MZ-jOqsn9dLnsb9iq7uTJAMboP6csLyTcbQSjRH9xTslkovrgJVQ_mufgBMZPWz6nPVCds/s1600/2015-04-10_182748.png" title="jellykom" width="320" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: justify;"><br /></div>2. Klik ganda ADO Connectio1, lalu klik "<b>Build</b>". Setelah muncul link properties, pilih "<b>OLE DB Provider for ODBC Drivers" </b>lalu klik Next. Isikan nama Data Source yang sebelumnya telah dibuat pada ODBC Conncetor (contoh: belajar). Klik Test untuk ujicoba.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiptltrSyYqzd2r4IqjI95KuC0CBWgM8K9q07xSqFw8rUPAzJLK-maIZ-OBXT0dh1p2REjImZ2Titt2iaov_qEgz7Jgn0h5_Qvx71bD6j9rl0b5Pf2y0mRXvXoWIMj3GLe2SFIFdNXyq4M/s1600/jellykom.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="251" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiptltrSyYqzd2r4IqjI95KuC0CBWgM8K9q07xSqFw8rUPAzJLK-maIZ-OBXT0dh1p2REjImZ2Titt2iaov_qEgz7Jgn0h5_Qvx71bD6j9rl0b5Pf2y0mRXvXoWIMj3GLe2SFIFdNXyq4M/s1600/jellykom.jpg" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: justify;">3. Seting Komponen lain dengan konfigurasi dibawah ini:</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5jYL_AnE_5Eo4VDTkURFGVAVzp0o8qHyfNYnCUhc8um6YlnolcAR-4EdoQA-WzE-HXi9OHBWTtiImfNQivGC7Fq9_vfRVbIyc_R8wibicQwf_7llyUBDlgLkMs_2_rhMh4iyXJZJ0_AU/s1600/jellykom.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5jYL_AnE_5Eo4VDTkURFGVAVzp0o8qHyfNYnCUhc8um6YlnolcAR-4EdoQA-WzE-HXi9OHBWTtiImfNQivGC7Fq9_vfRVbIyc_R8wibicQwf_7llyUBDlgLkMs_2_rhMh4iyXJZJ0_AU/s1600/jellykom.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"></div>4. Finish...<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZKQnHVdadHM1O-DiXq3bd6BeaPHDYtLGaT6hq0eXOmOZcXj-wg8dI6PG_XubpJhDq2UgUXxkc6IlwAXUyJAIp8mI6cdZRFqYgMHbQ11xoPFe7Z0Sp1aQh58ei65VSdWhtzGRWqYj9Eyo/s1600/2015-04-10_185234.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZKQnHVdadHM1O-DiXq3bd6BeaPHDYtLGaT6hq0eXOmOZcXj-wg8dI6PG_XubpJhDq2UgUXxkc6IlwAXUyJAIp8mI6cdZRFqYgMHbQ11xoPFe7Z0Sp1aQh58ei65VSdWhtzGRWqYj9Eyo/s1600/2015-04-10_185234.png" width="320" /></a></div><br />Sekian yang bisa saya bagikan dengan sobat sekalian. Apabila sobat belum paham dengan tutorial diatas, sobat bisa menanyakannya langsung dengn saya. Semoga bermanfaat.<br />Good Luck...<br /><br />

Posted by Hii Sekai