More than 3 years have passed since last update.

特定IPからMySQLへのアクセスを許可する

Last updated at 2020-07-18Posted at 2020-07-18

環境

$ mysql --version
mysql  Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

> create user 'username'@'192.168.1.1' identified by 'password';
> grant all privileges on dbname.* to 'username'@'192.168.1.1';