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 and while there doesn't seem to be a solid … [Read more...] about MySQL Remote Acccess via cPanel – DHCP – Dynamic IP
MySQL
How to Change the Root MySql Password in Windows (video)
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 via the MySql console, but I believe that the method in the video below (using the … [Read more...] about How to Change the Root MySql Password in Windows (video)
How to Setup a Local PHP/MySql Test Environment with WAMPSERVER
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 on your local PC using WAMPSERVER. For this tutorial I … [Read more...] about How to Setup a Local PHP/MySql Test Environment with WAMPSERVER
Free MySQL GUI tools for Database Development and Maintenance
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 I still wind up using these free GUI tools for MySql … [Read more...] about Free MySQL GUI tools for Database Development and Maintenance
Create a New Database in MySQL Query Browser
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 dialog box about the default schema (i.e. database). … [Read more...] about Create a New Database in MySQL Query Browser