Useful MySQL Tricks

This was originally going to be an article, but I got sidetracked whilst drafting it, so haven’t really got much further than scrawling a couple of notes down! It may be of use to some though; It’s also now been superseded by a (slightly) more complete MySQL Cheatsheet   Removing Tables based on their Prefix […]

Read More

Resetting MySQL Admin Users Password when Forgotten

It happens to the best of us, you set a password a long time ago and just cannot remember what it was!. This Documentation will talk you through the process of resetting the admin users password on MySQL   There are two sets of steps, depending on your setup. The initial steps, however, remain the […]

Read More

MySQL Cheat sheet

I started an article on basic MySQL Tips and Tricks a little while ago, but never quite finished it. This documentation contains those tips as well as some additional techniques I’ve picked up Tables Clone Table Structure CREATE TABLE new_tbl_name LIKE tbl_name;   Clone Table (including Data) CREATE TABLE new_tbl_name SELECT * FROM tbl_name;   […]

Read More