Skip to content

Instantly share code, notes, and snippets.

View someshkar's full-sized avatar
🧠
how 2 buidl AGI?

Somesh Kar someshkar

🧠
how 2 buidl AGI?
View GitHub Profile

Setup MySQL remote access on any server

This has been tested on AWS, but should work the same pretty much anywhere.

A simple guide for quickly setting up MySQL remote access on any VPS. This involves creating a new user (other than root) and changing the mysqld config to make it listen on all network interfaces.

Step 1: Install MySQL

Run these commands to install MySQL on Debian based operating systems:

sudo apt update
sudo apt install mysql-server

Keybase proof

I hereby claim:

  • I am someshkar on github.
  • I am someshkar (https://keybase.io/someshkar) on keybase.
  • I have a public key ASC2RLMOisb3hIwzEtU29yA91ACrikP7RcdUDEF8Mh1iOgo

To claim this, I am signing this object:

@someshkar
someshkar / redirect.html
Created September 9, 2018 15:47
Make a guaranteed HTML redirect page, just in case meta refresh doesn't work.
<!DOCTYPE HTML>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<meta http-equiv="refresh" content="0; url=[REDIRECT_URL]">
<script type="text/javascript">
window.location.href = "[REDIRECT_URL]"
</script>
<title>Page Redirection</title>
</head>