사용자 제거 후 재생성 권한 추가

delete from user where user='usrname';

GRANT USAGE ON *.* TO 'usrname'@'localhost' IDENTIFIED BY 'passwd';

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

FLUSH PRIVILEGES;