Using introspectdb with MySQL sakila and world databases

[Ram Munjuluri]

Hello,

I am a newbie to django, trying to create the models from the tables in MySQL for the following

1. Sakila database

2. World database 

when I execute 

> python manage.py inspectdb --database world city

I get the following error message (this is definitely not a warning as I do not see any models generated)

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)

I have tried a lot of message boards for a possible solution, but have hit the wall.

Has anyone tried these databases from MySQL to generate the models?

I am using

1. MySQL 8.0

2. Python 3.6.5

3. Django 2.0.7

Any help or pointers are really appreciated.

Kind regards

-Ram