Loading ...Three ways to recover a root user password: The order of solutions here under gets more creative on the way down :) 1. obviously, before starting messing around check my.cnf or scripts for passwords entries, then try home directories for password files 2. secondly – can you restart mysql? if yes, restart with –skip-grant-tables, log [...]
As a continuation to a previous blog post last week and inspired by Kedar I have created a small script to export tables, stored procedures, functions and views into their respective file. It works for multiple databases where you can specify a list of databases too and although things like events, triggers and such are [...]
Once every so often something bugs me enough to look up and here is today’s bugger! Sorting files and folders in Mac’s Finder by type, folders first! In essence: 1. Select Finder, click on Go from the menu bar and select Go to Folder 2. From the dialog box that opens, type: /System/Library/CoreServices/ and press [...]
This is a simple mysql circular replication implementation on a single machine (just a proof of concept) which can easily be done on a broader scale. Just be aware of the cons of circular replication which mainly gets down to: once a node freaks out or stops for one reason or the other, it’s a [...]