Skip to content

Instantly share code, notes, and snippets.

@pacmac

pacmac/mysql_native_pwd.sql

Created October 15, 2021 00:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pacmac/e50aedce34c05be43abe081046162688 to your computer and use it in GitHub Desktop.
Save pacmac/e50aedce34c05be43abe081046162688 to your computer and use it in GitHub Desktop.
Download ZIP
Set native password for mysql connection & allow root connection from any ip (allowed by firewall)
Raw
mysql_native_pwd.sql
; allow root access from any host
GRANT ALL ON *.* to 'root'@'%' IDENTIFIED BY 'your-password-here';
; switch to native passwords
update mysql.user set plugin = 'mysql_native_password' where User='root';
; apply changes
Flush privileges;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment