User Tools

Site Tools


docs:tips_n_tricks:mysql.html

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
docs:tips_n_tricks:mysql.html [07.11.2010 11:49 CET] peterdocs:tips_n_tricks:mysql.html [13.05.2013 18:32 CEST] – [MySQL] peter
Line 1: Line 1:
 ====== MySQL ====== ====== 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 ===== ===== Recover on Debian =====
  
docs/tips_n_tricks/mysql.html.txt · Last modified: 13.05.2013 18:35 CEST by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki