Fix Mysql #1273 unknown collaction:'utf8mb4_unicode_ci' – Onephin

Thanks for Like | share | Comment | Subscribe
Sorry for Audio Problem. but you can solve your problem by watching video.

Worked like charm 😀 Thanx

mera to phpmyadmin hi ni khul ra

Bro your a life saver… thank you so much

Hi, I have the same problem with utf8mb4,when I change that in utf8 I successfully import tables,but procedures and functions dont. There is error
Error
SQL query:

CREATE DEFINER=`mysql.sys`@`localhost` PROCEDURE `create_synonym_db` (IN `in_db_name` VARCHAR(64), IN `in_synonym` VARCHAR(64)) MODIFIES SQL DATA
SQL SECURITY INVOKER
COMMENT 'n Descriptionn n Takes a source database name and synonym name, and then creates the n synonym database with views that point to all of the tables withinn the source database.n n Useful for creating a "ps" synonym for "performance_schema",n or "is" instead of "information_schema", for example.n n Parametersn n in_db_name (VARCHAR(64)):n The database name that you would like to create a synonym for.n in_synonym (VARCHAR(64)):n The database synonym name.n n Examplen n mysql> SHOW DATABASES;n +——————–+n | Database |n +——————–+n | information_schema |n | mysql |n | performance_schema |n | sys |n | test |n +——————–+n 5 rows in set (0.00 sec)n n mysql> CALL sys.create_synonym_db(''performan[…]
MySQL said: Documentation

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLSTATE 'HY000' SET MESSAGE_TEXT = v_db_err_msg; END IF; SELECT SCHEMA_NAME IN' at line 4

I hope so that you can help me.

works fine!

Brilliant – thank you so much saved me some hassles

thanks you so much

It again showed me the same error #1273 after doing all steps that you have performed ??