CODEWITHSUNDEEP
mysql
superuserdo
superuserdo

Reputation: 1657

Change Server and Client Collation and Charsets in mysql

I need to change my mysql server variables one by one (without using the my.cnf file). I need it to look like this

enter image description here

How can I change these variable names without editing the my.cnf?

UPDATE

This is what it looks like now.

enter image description here

Upvotes: 0

Views: 60

Answers (1)

AdamMc331
AdamMc331

Reputation: 16691

Can you run update statements on the table?

UPDATE myTable SET value = 'utf8mb4_unicode_ci' WHERE variable_name = 'collation_connection';

And so on for the other necessary updates.

Upvotes: 1

Related Questions