select user, host from mysql.user order by 1,2;
CREATE USER [계정명]
@[접속 IP]
IDENTIFIED BY [비밀번호]
;
GRANT {권한}
ON {테이블명}
TO {계정}
;
EX )
GRANT SELECT, PROCESS, SHOW DATABASES, SHOW VIEW ON . TO [계정명]
@[IP]
;
show grants for '{계정}';
Mysql 8.0
CREATE USER [계정명]
@[IP]
identified with mysql_native_password as '*77B368A87EAD78B0629FC94070814833DAAADE0A';
계정 lock 해제
ALTER USER [계정명]
account unlock;