Posts Tagged ‘user.myd’

Recovering a MySQL `root` password – Three solutions

Posted: 21st March 2011 by Darren Cassar in Intermediate, Linux, Mac OS, MySQL, Solaris
Tags: , , , , , , ,
1

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

MySQL – changing a user password

Posted: 21st March 2011 by Darren Cassar in MySQL
Tags: , , , , , , ,
2

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