프로그래밍 Programming
MySQL Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
문장전달자
2015. 10. 3. 23:28
728x90
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root'
Error Code: 1175.
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.031 sec
안전모드 해제를 위해서는 Edit > Preferences > SQL Editor> Other 항목에서 "Safe Mode" 부분을 체크 해제한다.
728x90