Clean mysql import UTF8 and IDENTIFIER root

PHOTO EMBED

Mon Jul 14 2025 09:59:05 GMT+0000 (Coordinated Universal Time)

Saved by @swina #bash #mysql

sed -i'' -e 's/DEFINER=`[USERNAME]`@`%`/DEFINER=`root`@`%`/' [file_path].sql
sed -i'' -e 's/utf8mb4_uca1400_ai_ci/utf8mb4_general_ci/' [file_path].sql
content_copyCOPY

To change DB user and replace a collation with a standard one