MySQL Character Set Problems

Recently, there was a small project that needed to modify the MySQL character set. Therefore, according to the tutorial on the Internet, we found that MySQL could not be started and said on the internet, etcmy. cnf settings, MySQL is installed with rpm in the appearance project, and my is not found in etc. cnf, so I wrote a my. cnf is placed in the etc folder and cannot be started. Delete my. cnf, M

Recently, there was a small project that needed to modify the MySQL character set. Therefore, according to the tutorial on the Internet, it was found that MySQL could not be started and said on the internet,/etc/my. cnf settings, MySQL is installed with rpm in the appearance project, and my is not found in etc. cnf, so I wrote a my. cnf is placed in the etc folder and cannot be started. Delete my. cnf, M

Recently, a small project needs to modify the MySQL character set. Therefore, according to the online tutorial, it is found that MySQL cannot be started.

Then the internet says "/etc/my. it seems that MySQL is installed with rpm in the project, and there is no my In etc. cnf, so I wrote a my. cnf is placed in the etc folder and cannot be started. My. cnf is deleted and MySQL service is started successfully.

So it should be my. for cnf settings, open/var/lib/mysql/localhost. localdomain. error found in the err file,/usr/bin/mysqld: unknown variable 'default-character-set = utf8' comment my. this statement in cnf is successfully started and searched on the Internet. It is said that character_set_server = utf8 is used to replace default-character-set = utf8.

MySQL service restarted successfully. Check the character set and modify it successfully.