Skip to content

Instantly share code, notes, and snippets.

@alimranahmed

alimranahmed/Give remote and password access to a database.md

Last active January 18, 2021 10:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save alimranahmed/3056dbd0f143ff205369ef941655d238 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save alimranahmed/3056dbd0f143ff205369ef941655d238 to your computer and use it in GitHub Desktop.
Download ZIP
Scripts
Raw
Give remote and password access to a database
To access from remote
---------------------------------
mysql –u root -p
GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
For changing from sudo accessible to password accessible(auth_socket to mysql_native_password)
----------------------------------------------------------------------------------------------------
mysql –u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment