FeGM IT Wiki - snippets:mysql
https://wiki.feggm.de/
2026-06-07T09:25:11+00:00FeGM IT Wiki
https://wiki.feggm.de/
https://wiki.feggm.de/lib/exe/fetch.php?media=wiki:dokuwiki.svgtext/html2013-12-20T17:25:18+00:00Anonymous (anonymous@undisclosed.example.com)convert_timestamp
https://wiki.feggm.de/doku.php?id=snippets:mysql:convert_timestamp&rev=1387560318&do=diff
MySQL Timestamp Conversion
SELECT TIME(FROM_UNIXTIME(Substring('1365835646039', 1, 10))) AS Uhrzeit;text/html2013-12-20T17:25:18+00:00Anonymous (anonymous@undisclosed.example.com)reset_root
https://wiki.feggm.de/doku.php?id=snippets:mysql:reset_root&rev=1387560318&do=diff
MySQL - reset root password
*
root@server# service mysql stop
*
root@server# mysqld_safe --skip-grant-tables &
*
root@server# mysql -u root
*
mysql> use mysql;
*
mysql> update user set password=PASSWORD("mynewsecretpassword") where User='root';text/html2013-12-20T17:25:18+00:00Anonymous (anonymous@undisclosed.example.com)start
https://wiki.feggm.de/doku.php?id=snippets:mysql:start&rev=1387560318&do=diff
MySQL Snippets
* reset root password
* Timestamp Conversion