Tom's Subject Directory & City Building Fan Site

Visual Basic 2008 & Mysql Version 5 Index

This article is made to document the creation of Windows® applications using Visual Basic.NET and MySQL. Because this is not a web-based application, we will be building our application using the built-in MySQL privilege system.

You can allow external web servers to access your MySQL databases by adding their domain name to the list of hosts that are able to access databases on your web site. You can allow another person using your application access your MySQL databases by adding their IP address to the list of hosts that are able to access databases on your web site. When you use the security built-into MySQL, you inherit a sturdy privilege management system that has been thoroughly reviewed and tested. Because this is not a web-based application, we will be building our application using the built-in MySQL privilege system. Setting your IP address via the "Remote MySql" link on your control panel or giving your network administrator your IP at the top left of this page will allow you access MySql remotely so long as your IP doesn't change. Setting the host to a wildcard only (%) will allow any host. This is highly insecure and should only be done with the greatest precaution. Building precautions into your application should be a priority if "Allow Any Host" is used.

This article has several pages which are listed below;

• Part I
  
  
• Part II
  
  
• Part III
  
  
• Login Form UI & Properties
  
  
• Complete Source Code
  
  
• Download .vb file used in example