Loading ...Hi, Maybe you heard about salaryshare.me or maybe you haven’t, but either way, if you are a MySQL DBA in the US you should participate (ananymously) in order to learn how you compare to other MySQL DBAs. Fair enough, people have different experience level, some contract, some live in Santa Clara and some live in [...]
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 [...]
Disclaimer: This post is for educational purposes only and no responsibility will be taken if you execute any of the commands. You mess it, you fix it! Replacing a password for a user on MySQL can be done in at least four ways. Three ways at least. 1. set password for ‘user’@’host’=password(‘abc’); 2. grant usage [...]
The first EffectiveMySQL meetup will be held in NY on Tuesday 22nd March 2011 by Ronald Bradford. Details here The title of the talk is “How better indexes save you money”. Saving money? Hey sure thing :) I’m in Ronald. For those of you who do not know Ronald Bradford, he’s an Oracle Ace Director [...]