Posts Tagged ‘grants’

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 [...]

Securich 0.3.0

Posted: 19th August 2010 by Darren Cassar in MySQL, Uncategorized
Tags: , , , , , ,

Around these days last year I presented `securich` for the first time. It was at froscon 2009, barely knowing anybody, spending my 27th birthday in a hostel in Germany fixing some bugs before the actual presentation on a 10 inch netbook (my mac had some problems at the time but thats another story :)). I [...]

MySQL – IP vs DNS

Posted: 4th December 2009 by Darren Cassar in Databases, MySQL, Networking, OS, Solaris
Tags: , , , , ,

A MySQL is running happily on a machine situated in a land far far away. I grant access to a user@machine_aaaaaa (grant select on db.* to ‘user’@’machine_aaaaa’ identified by ‘password’; flush privileges;), send an email to the user saying it should run fine and happily go off my way. Mistake! It seems this user can’t [...]