mysql 사용자 권한 관련 (access denied) 발생시

//권한 한번에 주기
GRANT ALL privileges ON *.* TO 'root'@'localhost' IDENTIFIED BY '패스워드' WITH GRANT OPTION;
//mysql 중지, 시작
/etc/rc.d/init.d/mysqld stop
/etc/rc.d/init.d/mysqld start

//권한 필요 없이 들어가기
killall mysqld
/usr/bin/mysqld_safe --skip-grant &

INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv) VALUES('%', 'DB명', '사용자', 'Y', 'Y', 'Y', 'Y','Y','Y');
//권한 주기
update user set Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='Y', Drop_priv='Y',Reload_priv='Y',Shutdown_priv='Y',Process_priv='Y',File_priv='Y',Grant_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Show_db_priv='Y',Super_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Repl_slave_priv='Y',Repl_client_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y',Create_user_priv='Y',ssl_type='Y',ssl_cipher='Y',x509_issuer='Y',x509_subject='Y',max_questions='Y',max_updates='Y',max_connections='Y',max_user_connections='Y';
flush privileges;