mysql编码设置

最新推荐文章于 2024-09-12 12:42:46 发布

ZFENG123456

最新推荐文章于 2024-09-12 12:42:46 发布

阅读量103

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/ZFENG123456/article/details/84717964

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1、修改编码：http://blog.sina.com.cn/s/blog_7122661501018v70.html

设置默认编码show variables like 'character_set_%';

set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;
set collation_server = utf8_general_ci;

2、service mysql stop/restart/start

service mysqld stop/restart/start
repair table `app`.`performance_assessment_point`;