wiki:mysql_miscellaneous_commands
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
wiki:mysql_miscellaneous_commands [2021/04/29 14:47] – created antisa | wiki:mysql_miscellaneous_commands [2022/11/12 11:30] (current) – [Password change] add mysqladmin command antisa | ||
---|---|---|---|
Line 38: | Line 38: | ||
WHERE C.COLLATION_NAME IS NOT NULL AND C.TABLE_SCHEMA=' | WHERE C.COLLATION_NAME IS NOT NULL AND C.TABLE_SCHEMA=' | ||
</ | </ | ||
+ | |||
+ | ===== Password change ===== | ||
+ | USE mysql; | ||
+ | UPDATE user SET password=PASSWORD(" | ||
+ | FLUSH PRIVILEGES; | ||
+ | |||
+ | Or | ||
+ | |||
+ | mysqladmin -u root -p' | ||
+ | ===== Select only certain tables from DB ===== | ||
+ | mysql -p -N information_schema -e " | ||
+ | |||
+ | ===== Backup database directly on another server ===== | ||
+ | |||
+ | mysqldump –extended-insert=FALSE -uroot -pmypwd dbname tablename | pbzip2 -p4 -m1000 -c | ssh root@example.com 'cat > / | ||
+ | |||
+ | |||
====== Tested on ====== | ====== Tested on ====== | ||
* | * |
wiki/mysql_miscellaneous_commands.1619707640.txt.gz · Last modified: 2021/04/29 14:47 by antisa