Downgrading to 5.7.7 and installing "mysql-connector-python 8.0.11" through pip fixed the issue. Is this because the mysql-connector-python from MySQL/Oracle does not work with their own MySQL 8.0.11 version?
thanks -Ram On Friday, July 13, 2018 at 9:18:39 AM UTC+5:30, Ram Munjuluri wrote: > > thanks Melvyn. let me try to downgrade to MySQL 5.7.7 first. > > > > On Friday, July 13, 2018 at 3:13:23 AM UTC+5:30, Melvyn Sopacua wrote: >> >> On donderdag 12 juli 2018 19:27:23 CEST Ram Munjuluri wrote: >> >> > from django.db import models >> > # Unable to inspect table 'city' >> > *# The error was: (3719, "3719: 'utf8' is currently an alias for the >> > character set UTF8MB3, which will be replaced by UTF8MB4 in a future >> > release. Please consider using UTF8MB4 in order to be unambiguous.", >> None)* >> > >> > Any suggestion here please? I seem to be stuck here. >> >> Downgrade to MySQL 5.x or patch PyMySQL. More info: >> https://github.com/PyMySQL/PyMySQL/issues/690 >> >> -- >> Melvyn Sopacua >> > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to email@example.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/9fa45c4b-1eec-4d08-ab95-004d91647bca%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.