defect.ch - Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== MySQL ======

===== Create new User+DB =====

Create a database with a user which have full access.

Example data:
  * Username: u_example
  * Password: WXJ07sf7lO7X4kzxjA47j7diQ4Z309628XS3Xm5D1L
  * Databasename: db_example

//Notes://
  * //I use prefix u_ for users and prefix db_ for databases that I never mix them up.//
  * //I recommend passwords with 64 characters. They can be generated on [[https://pwgen.ch/]] for example.//


<code>
CREATE USER 'u_example'@'localhost' IDENTIFIED BY 'WXJ07sf7lO7X4kzxjA47j7diQ4Z309628XS3Xm5D1L';
CREATE DATABASE db_example;
GRANT ALL PRIVILEGES ON db_example.* TO 'u_example'@'localhost';
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]]//