• notice
  • Congratulations on the launch of the Sought Tech site

Detailed explanation based on MYSQL5.5 setting character set

I installed a mysql on the virtual machine, modified its my.cof file, and found that the configuration file is good Powerful, but I have a problem:

When setting the character set, set default under [client], [mysql] and [mysqld] respectively-character-set=utf8, but the following problems occur:


I checked one by one and found that it was caused by setting default-character-set=utf8  under [mysqld].View the/var/lib/mysql/${hostname}.err file:


The problem is that mysqld does not recognize default-character-set.I checked some information on the Internet and found that setting character_set_server=utf8  under mysqld is just fine.

Check the character set: show variables like'character%';


Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

order lipitor 10mg generic & lt;a href="https://lipiws.top/"& gt;order atorvastatin 20mg& lt;/a& gt; lipitor 40mg ca

Hiuazx

2024-03-08

Leave a Reply

+