Skip to content

Instantly share code, notes, and snippets.

@crashangelbr

crashangelbr/mysql > root@localhost access denied

Last active June 30, 2018 20:51
Show Gist options
  • Save crashangelbr/9a0cd4ead5313f94138c73a87b131f71 to your computer and use it in GitHub Desktop.
Save crashangelbr/9a0cd4ead5313f94138c73a87b131f71 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql > root@localhost access denied
mysql -uroot -p -h127.0.0.1 -P3306
if login, add networking em my.cnf
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';
FLUSH PRIVILEGES;
SET GLOBAL sort_buffer_size=1000000, SESSION sort_buffer_size=1000000;
SET @@global.sort_buffer_size=1000000, @@sort_buffer_size=1000000;
SET FOREIGN_KEY_CHECKS=0;
SET GLOBAL FOREIGN_KEY_CHECKS = 0;
SET GLOBAL max_allowed_packet=5000000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment