User Tools

Site Tools


percona

Differences

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]
felixonmars created
percona [2019/08/25 04:01]
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:
   * http://forums.fedoraforum.org/archive/index.php/t-20329.html   * 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://www.euperia.com/development/mysql-create-database-with-utf8-character-set-syntax/1064
 +  * https://stackoverflow.com/a/50197630
  
percona.txt · Last modified: 2019/08/25 04:01 by felixonmars