Differences

This shows you the differences between two versions of the page.

--- docs:tips_n_tricks:mysql.html [07.11.2010 10:53 CET] – peter
+++ docs:tips_n_tricks:mysql.html [13.05.2013 18:35 CEST] (current) – peter
@@ Line 1: / Line 1: @@
 ====== MySQL ======
+===== Change your password =====
+The tradtional way of changing passwords on UNIXoid systems is an command line tool, that asks you old and new passwords without echoing or logging the typed characters.
+Unfortunately, this is not common and bad documented for MySQL administration, most documentations point you to SQL or CLI commands that tend to be logged in history files containing the clear text password. However, secretly changing your password __//is//__ possible since MySQL 5.5.3:
+  mysqladmin -p -u <user> -h <host> password
+will ask you for the old and new password without echoing or logging.
 ===== Recover on Debian =====
@@ Line 59: / Line 67: @@
 where ''<password>'' should be the password you used before as it is found e.g. in ''~/.mythtv/mysql.txt'' of your mythfrontend user.
+===== References =====
+These google hits did help me
+  * http://debianforum.de/forum/viewtopic.php?f=32&t=121144
+  * http://debianforum.de/forum/viewtopic.php?p=16418#p16418
+  * http://ubuntuforums.org/showthread.php?t=502982
+{{tag> MySQL restore recover password}}
+{{entry> MySQL}}
+{{entry> restore}}
+{{entry> recover}}
+{{entry> password}}