Tag: MariaDB

How to convert an entire MySQL database character set and collation to UTF-8?

Jan 21, 2015

—

by

John Walker

in SysAdmin

I found myself in need of upgrading a number of older wordpress sites to change from the old latin1_swedish_ci to UTF-8, both the character set and collation. I utilized a command line SQL prompt to accomplish this. Modify the appropriate parameters “test” for your database, and “yourpasswordhere” with your password, ymmv, and have fun. I am…