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 revision Previous revision
percona [2019/05/22 14:55]
felixonmars
percona [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