Kaigai Blog living abroad in my twenties

【My Study Load】mySQL CODING

MySQL Programming

mySQL CODING

Connecting to the database remotely via terminal

  • 1. Grant access in Cpanel
  • 2. Type the code in your local terminal

1. Grant access in Cpanel

At first, go to this site to get your computer’s IP address.

After that, open the Remote MySQL® which you can find in Cpanel, and type that IP address in “Add Access Host”.

2. Type the code in your local terminal

mysql -u username -h host(IP ADDRESS) -p