Differences

This shows you the differences between two versions of the page.

--- apps:mysql [2014-06-16 22:16] – created root
+++ apps:mysql [2016-11-19 16:17] – [Create new User+DB] root
@@ Line 6: / Line 6: @@
 Example data:
   * Username: u_example
   * Password: WXJ07sf7lO7X4kzxjA47j7diQ4Z309628XS3Xm5D1L
@@ Line 13: / Line 12: @@
 //Notes://
   * //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 42 characters. They can be generated on [[https://strongpasswordgenerator.com/]] for example.//
@@ Line 22: / Line 21: @@
 FLUSH PRIVILEGES;
 </code>
+===== Delete DB+USer =====
+Example data:
+  * Username: u_example
+  * Databasename: db_example
+<code>
+DROP DATABASE db_example;
+DROP USER u_example@'localhost';
+</code>
+===== 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://dev.mysql.com/doc/refman/5.6/en/query-cache-operation.html|How the Query Cache Operates]]//