User Tools

Site Tools



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:
   *   *
   *   *
 +  *
percona.1558536928.txt.gz · Last modified: 2019/05/22 14:55 by felixonmars