Recently, John and I have been doing a lot of database work using MySQL and have had to connect to several large databases and manage them correctly. This can be a daunting task without a tool to easily do so. This is where Heidi SQL comes in. This tutorial will walk you through downloading, installing, and configuring Heidi SQL to use against your MySQL databases.
In on of our last tutorials we covered how to verify that a user’s email address is formatted correctly as well as verify that it goes to a valid domain name. That is great, but still not a great way to make sure a user actually owns or uses that e-mail address. This tutorial will walk you through one method of sending the user an e-mail upon signing up that gives them a link to activate their account.
This tutorial will walk you through configuring your SQL server with credentials for applications and users to connect with. This will allow you to determine who has what type of access as well as how they can update the tables in the database.
This tutorial will walk you through what you need to do to start using the installation of Microsoft SQL 2008 Express Edition that we did in the last tutorial. We will need to configure the services to allow incoming connections and we will also go through creating the database as well as some tables to insert information.
This tutorial will walk you through installing Microsoft’s SQL Server 2008 Express Edition. This will allow us to create a database and start writing more advanced applications in Visual Basic that require a database.
In this tutorial I will show you how to add a simple search box to query a MySQL database. This tutorial is a continuation of the “How to Access a MySQL Database Using PHP” tutorial.
Since writing that original tutorial I have created a local WAMP test environment. I have created the database “test” with a table “testable”. The table contains the following fields: