User Tools

Site Tools



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

Link to this comparison view

Next revision
Previous revision
percona [2017/01/05 06:29] – created felixonmarspercona [2019/08/25 04:01] (current) felixonmars
Line 9: Line 9:
 ==== Create UTF-8 Database and User ==== ==== Create UTF-8 Database and User ====
 <code> <code>
-CREATE DATABASE `mydb` CHARACTER SET utf8 COLLATE utf8_general_ci+CREATE DATABASE `mydb` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; 
-GRANT ALL ON `mydb`.* TO `username`@localhost IDENTIFIED BY 'password';+CREATE USER 'username'@localhost IDENTIFIED BY 'password'
 +GRANT ALL PRIVILEGES ON `mydb`.* TO 'username'@localhost WITH GRANT OPTION;
 </code> </code>
Line 70: Line 71:
   *   *
   *   *
 +  *
percona.1483597790.txt.gz · Last modified: 2017/01/05 06:29 by felixonmars