mysql 8 계정생성

> CREATE DATABASE home CHARACTER SET utf8 COLLATE utf8_bin;

 

> CREATE USER 'home'@'localhost' IDENTIFIED BY 'home' PASSWORD EXPIRE NEVER;

-- 이것만 하면 아래 오류 발생 
Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found

> ALTER USER 'home'@'localhost' IDENTIFIED WITH mysql_native_password BY 'home';

GRANT ALL PRIVILEGES ON home.* TO 'home'@'localhost';