docs:tips_n_tricks:mysql.html
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
docs:tips_n_tricks:mysql.html [06.11.2010 17:35 CET] – peter | docs:tips_n_tricks:mysql.html [13.05.2013 18:35 CEST] (current) – 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, | ||
+ | |||
+ | mysqladmin -p -u < | ||
+ | |||
+ | will ask you for the old and new password without echoing or logging. | ||
===== Recover on Debian ===== | ===== Recover on Debian ===== | ||
Line 30: | Line 38: | ||
cd / | cd / | ||
- | rm -v host.* user.* db.* func.* time_zone.* | + | rm -v host.* user.* db.* func.* time_zone.* proc.* procs_priv.* tables_priv.* columns_priv.* |
install_mysql_db | install_mysql_db | ||
Line 48: | Line 56: | ||
/ | / | ||
- | where ''< | + | where ''< |
==== Recover MythTV privileges ==== | ==== Recover MythTV privileges ==== | ||
Line 59: | Line 67: | ||
where ''< | where ''< | ||
+ | ===== References ===== | ||
+ | These google hits did help me | ||
+ | |||
+ | * http:// | ||
+ | * http:// | ||
+ | * http:// | ||
+ | |||
+ | {{tag> MySQL restore recover password}} | ||
+ | {{entry> MySQL}} | ||
+ | {{entry> restore}} | ||
+ | {{entry> recover}} | ||
+ | {{entry> password}} |
docs/tips_n_tricks/mysql.html.1289061354.txt.gz · Last modified: 06.11.2010 17:35 CET by peter