Tips and Tricks

Whenever you upgrade your MySQL installation, make sure to upgrade any client that uses it. In some cases, clients that use a version prior to 4.1 will have a problem authenticating against the MySQL database if the latter has a post 4.1 version. The trick is that after 4.1 (i.e. 4.11 and up), MySQL changed [...]

It’s always about data. What’s the use of any system without the data it relies on? Setting up a database replication is one of many steps that should be taken in order to preserve data, preventing any loss and making disaster recovery easier. Luckily, it’s easy with MySQL. So let’s suppose we have two servers [...]

It is quite frequent that an administrator simply forgets his mysql’s root password. Luckily, it is quiet easy to reset it, here are the steps: SSH as root to your machine Turn off the mysqld daemon if running RedHat/Fedora users can do so by executing:  service mysqld stop Run safe_mysqld by executing: safe_mysqld –skip-grant-tables (this [...]

For the follows out there who do not know how to import coma separated data into mysql from the prompt, here it is: Assume: PATH is the path to the csv file (can be relative to the directory you were in before logging into mysql) TABLE is the table name that you have already created [...]