In your Mysql configuration change the default-character-set operative under the [mysqld] tab. For example: [mysqld] default-character-set=utf8 Don’t forget to restart your Mysql server afterwards for the changes to take effect.
I had the same problem recently. I did these 3 things and it worked: Made sure the Collation of the exported database is the same as the newly created one. Made these changes in my php.ini(xampp/php/php.ini) file max_execution_time = 5000 max_input_time = 5000 memory_limit = 1000M post_max_size = 750M upload_max_filesize = 750M Made this change … Read more
You can use phpMyAdmin for python project, because phpMyAdmin is meant for MySQL databases. If you are using MySQL, then regardless of whether you are using PHP or python, you can use phpMyAdmin.
This works and is under active development: http://www.adminer.org/