User Tools

Site Tools


percona

Differences

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

Link to this comparison view

Last revision Both sides next revision
percona [2017/01/05 06:29]
felixonmars created
percona [2019/05/22 14:55]
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'; GRANT ALL ON `mydb`.* TO `username`@localhost IDENTIFIED BY 'password';
 </code> </code>
percona.txt ยท Last modified: 2019/08/25 04:01 by felixonmars