Enabling and managing binary logging will make it more likely that you can recover your database to a specific point in time. These point in time recoveries require proper backups as well as having your MySQL server instance configure for…
MySQL stores user’s password in a crypto format. It wasn’t too long ago that the default length of the crypto password was stored in a 16 character length. More recently, MySQL has changed their password length capability scheme to up…
Sometimes we need to migrate our databases to a new MySQL server. It is easy to move the databases, but without the users and their permissions, our new databases would be worthless. Below is a step-by-step on migrating MySQL users…
Master Slave MySQL Replication Summary Master / Slave replication in MySQL is a great way to store an exact replica of your database on another machine in another location as part of a disaster recovery plan. Before setting up Master…