Skip to content

Instantly share code, notes, and snippets.

@Vladnev
Created November 28, 2017 15:18
Show Gist options
  • Save Vladnev/d0bec5f749805d770f8846d2114c2d89 to your computer and use it in GitHub Desktop.
Save Vladnev/d0bec5f749805d770f8846d2114c2d89 to your computer and use it in GitHub Desktop.
First start of mysql server
sudo mysql -u root
DROP USER 'root'@'localhost';
CREATE USER 'root'@'localhost' IDENTIFIED BY ''; - for all hosts change localhost to %, not recommend
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
FLUSH PRIVILEGES;
exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment