MySQL 8.0 enable remote access 2020-08-18 02:57

Follow this article to download and install mysql. In this page I will show you how to enable remote access.

  1. After login, create new user with password.
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'rjyWzEz7A3=r66';
Query OK, 0 rows affected (0.08 sec)
  1. Give the privileges
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.10 sec)

Now you can try to log in remotely. It is said on the Internet that the value of bind_address in the configuration file needs to be changed. I did not find it here but it does not prevent me from logging in remotely.