Though it positively has its uses, not everyone like phpMyAdmin for managing databases.  Personally I still like to use the good old MySQL Query Browser, but when your database is hosted via cPanel, getting remote access from your local machine (e.g. your development laptop) can be a pain in the neck.  I've done extensive research…

In this tutorial we will go over how to change the root password in MySql.   Note that we are not going to use the MySql console, and like with the mysqldump command,  we will be using the windows command prompt.  The root password can also be changed by direct manipulation of the sql tables…

One of the most important things we do as web developers is test websites.  While it’s easy to test static .html pages on your local development machine, it’s not as easy to test dynamic pages without some tweaking first.  In this tutorial I will review how to quickly and easily setup a PHP/MySql development environment…

I've been working with mysql/php for many years, and although there is no substitute for the command line when it comes to certain tasks (like running mysqldump), there are a few MySql GUI programs that I use for almost all of my mysql database development.   I've tested many commercial products, but in the end…

MySQL Query Browser is an excellent (and FREE) GUI tool for managing your MySQL databases. In order to create a new database, follow the steps below. 1. Open MySQL Query Browser. You will be presented with the login screen. Fill in the appropriate information and click OK. 2. You may be presented with the following…