apps:mysql
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
apps:mysql [2014-06-16 22:16] – created root | apps:mysql [2023-01-02 18:10] (current) – Manuel Frei | ||
---|---|---|---|
Line 6: | Line 6: | ||
Example data: | Example data: | ||
- | |||
* Username: u_example | * Username: u_example | ||
* Password: WXJ07sf7lO7X4kzxjA47j7diQ4Z309628XS3Xm5D1L | * Password: WXJ07sf7lO7X4kzxjA47j7diQ4Z309628XS3Xm5D1L | ||
Line 13: | Line 12: | ||
//Notes:// | //Notes:// | ||
* //I use prefix u_ for users and prefix db_ for databases that I never mix them up.// | * //I use prefix u_ for users and prefix db_ for databases that I never mix them up.// | ||
- | * //I recommend passwords with 42 characters. They can be generated on [[http://strongpasswordgenerator.com/]] for example.// | + | * //I recommend passwords with 64 characters. They can be generated on [[https://pwgen.ch/]] for example.// |
Line 22: | Line 21: | ||
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
</ | </ | ||
+ | |||
+ | ===== Delete DB+USer ===== | ||
+ | |||
+ | Example data: | ||
+ | * Username: u_example | ||
+ | * Databasename: | ||
+ | |||
+ | < | ||
+ | DROP DATABASE db_example; | ||
+ | DROP USER u_example@' | ||
+ | </ | ||
+ | |||
+ | ===== Caching ===== | ||
+ | |||
+ | To make use of the MySQL query cache, the statements have to be exactly the same (including case): | ||
+ | |||
+ | Following statements are treated differently by the cache but deliver the same results: | ||
+ | * SELECT * FROM tbl_name | ||
+ | * select * FROM tbl_name | ||
+ | * select * from tbl_name | ||
+ | |||
+ | // More details: [[http:// |
apps/mysql.txt · Last modified: 2023-01-02 18:10 by Manuel Frei