User Tools

Site Tools


percona

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
percona [2019/05/22 14:55] felixonmarspercona [2019/08/25 04:01] (current) felixonmars
Line 10: Line 10:
 <code> <code>
 CREATE DATABASE `mydb` CHARACTER SET utf8mb4 COLLATE utf8mb4_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