migrate Error
1044
사용자 액세스 권한 부여하면 해결
1142
사용자에게 INSERT, UPDATE 등 모든 권한 부여하면 해결
2059 <NULL>
데이터베이스 설정(사용자 추가 및 권한 부여)
ValueError: The database backend does not accept 0 as a value for AutoField.
각 앱 별로 migration 파일 삭제 (__init.py__ 파일 제외) 후 다시 migrate 실행
##################################################################
[문제]
Cannot Connect to DatabaseServer (mysql workbench)
Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:Can't connect to mysql server on '127.0.0.1'(10061) Please: 1. Check that mysql is running on server 127.0.0.1 2. Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed) 3. Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines) 4. Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
[해결 방법]
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'secret';