title: What is the best, easiest and free location database for MySQL?
body: <p>My users need to be able to put in a shipping and billing address.  However, the only field I want typed is the street address.  There's no way I could input every city, state, territory, country and zip code into a database, so it'd be nice if there is one to download already for MySQL that has the relationships between the tables.  All I've seen so far was recommendations of files to download and input into the database.  I'd have to create the tables and their relationships, choose the fields I need from the files, and hope they're right.  But does anyone know of a free one out there already, preferably with updates?  Or an API that allows you to connect to it based on user input?  Any and all help is appreciated.</p>
  
  <p>Also, I'm not looking for anything with latitude, longitude, IP addresses or any more information other than city, state, territory/province, country and zip code.  Thanks.</p>
  
  <h2>Edit</h2>
  
  <p>I'm not looking for a solution that only has the fields I need, I'm simply looking for a solution and I'll take out the fields I don't need.  If there is a database that is easy to set up that already has Lat, Long, IP, etc., I'll simply remove them.  I just simply stated I don't need those fields so if there is a solution that doesn't already have those fields, then that's awesome.</p>