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)
MySQL
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
mySql error 1005 (errno: 150)
mySql error 1005 (errno: 150) solution This mysql error occurs when creating a table with the InnoDB engine and is basically telling you that there is a "foreign key problem" with your schema. The thing to check to fix this error is to make sure that your foreign key fields are of the same datatype as their source fields. As an example, assume the main table is "people", … [Read more...] about mySql error 1005 (errno: 150)