개발관련/error
[MYSQL] 5.0.15 Access denied for user '[사용자명]'@'%' to database '[db명]'
Josiah
2022. 6. 23. 13:04
728x90
grant select on [db명].* to '[사용자명]'@'%' ;
flush privileges;
#권한 즉시 부여 flush privileges
예) grant create on test.* to 'a'@'%';
grant select, insert, update, delete on test.* to 'a'@'%';
flush privileges;
2022.06.30 - [개발관련/back-end] - MYSQL reference_manual-4.1-en / 관련 쿼리 query
2022.07.04 - [개발관련/back-end] - MYSQL reference_manual-5.0-en / 관련 쿼리 query