Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // MySQL often returns with the 1396 error code when you try to create a user
- // 1396 (HY000): Operation CREATE USER failed for [user]
- // To avoid the error we have to assume we already have that user and follow the following order:
- drop user [user]@localhost;
- FLUSH PRIVILEGES;
- CREATE USER '[user]'@'localhost' IDENTIFIED BY 'M@RRyXm@S1981';
- GRANT ALL PRIVILEGES ON *.* TO '[user]'@'localhost' WITH GRANT OPTION;
Add Comment
Please, Sign In to add comment