All public logs
Jump to navigation
Jump to search
Combined display of all available logs of Dave-Wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).
- 02:14, 15 February 2024 Dave talk contribs created page MySQL (Created page with "=mysqldump= ===Dump a Single Database=== mysqldump -u root -p --databases [db-name] > db_$(date +%F).sql ===Dump ALL Databases=== mysqldump -u root -p --all-databases --single-transaction > all-db_$(date +%F).sql =Users and Permissions= ===Show MySQL users, their passwords and hosts=== SELECT user,host,password FROM mysql.user; ===Show privileges for a user from a given host=== SHOW GRANTS FOR 'user_name'@'host'; ===Create a user that can login from localhost...")