Differences

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

--- percona [2017/01/05 06:29] – created felixonmars
+++ percona [2019/08/25 04:01] (current) – felixonmars
@@ Line 9: / Line 9: @@
 ==== Create UTF-8 Database and User ====
 <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>
@@ Line 70: / Line 71: @@
   * http://forums.fedoraforum.org/archive/index.php/t-20329.html
   * https://www.euperia.com/development/mysql-create-database-with-utf8-character-set-syntax/1064
+  * https://stackoverflow.com/a/50197630