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 [email protected]. To post to this group, send email to [email protected]. 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.

