Guest User

Untitled

a guest
Mar 4th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. // MySQL often returns with the 1396 error code when you try to create a user
  2. // 1396 (HY000): Operation CREATE USER failed for [user]
  3. // To avoid the error we have to assume we already have that user and follow the following order:
  4.  
  5. drop user [user]@localhost;
  6. FLUSH PRIVILEGES;
  7. CREATE USER '[user]'@'localhost' IDENTIFIED BY 'M@RRyXm@S1981';
  8. GRANT ALL PRIVILEGES ON *.* TO '[user]'@'localhost' WITH GRANT OPTION;
Add Comment
Please, Sign In to add comment