How to change all columns' and tables' collation to 'utf8_bin' in MySQL

Run The following Command

SELECT * FROM information_schema.COLUMNS WHERE table_schema = '<dbname>' AND collation_name != 'utf8_bin';

SELECT * FROM information_schema.COLUMNS WHERE table_schema = '<dbname>' AND collation_name != 'utf8_bin' \G;

use <dbname>;

SET foreign_key_checks = 0;

ALTER TABLE <table name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;

SET foreign_key_checks = 1;


Note: for more detail info visit following link
https://confluence.atlassian.com/jirakb/how-to-change-all-columns-and-tables-collation-to-utf8_bin-in-mysql-601456761.html