Everybody is use to the Open Source MySQL tools like phpMyAdmin, et cetera. I think you should also take a look at Quest’s Toad for MySQL. It’s quite powerful in letting you understand your data and MySQL’s SQL implementation.
Since folks tell me they like step-by-step instructions, especially my students, here are the setup instructions for Toad for MySQL. The first thing you’ll need to do before installing it is to download and install if it isn’t already installed Microsoft .NET Framework Version 2.0.
- Download the Quest Toad for MySQL MSI file. Click the Run button to begin the install provided you’ve installed the prerequisite Microsoft .NET Framework Version 2.0.
- On the Welcome to the Toad for MySQL Freeware Installation Wizard, click the Next button to continue.
- This is the license screen. Click the I accept the license agreement radio button, and click the Next button to continue.
- This is where you enter a user, which should auto fill for you. Click the Anyone who uses the computer radio button if it isn’t preselected for you, and the Next button to continue.
- You can change the destination folder or continue by clicking the Next button.
- This is the file extension page. I uncheck the
.sqlextension because I use another editor. Click the Next button to continue.
- This is where you take a couple minute break.
- I uncheck the release notes because they don’t get read until there’s a problem. Click the Finish button to continue.
- This is your launhed and started page. You need to configure an initial connection by clicking the Click here to create a new connection hyperlink.
- Here’s where you create a new connection. You need user name, password, database name, and port number. If you’ve not configured that in MySQL, you can go to the botton of this blog post for creating a database and user, and granting the user full rights on the database. Then, enter the appropriate information and connect. If all those values were correct, you are now in Toad.
You have now installed Quest’s Toad for MySQL.