-- 设置mysql字符集
set character_set_client=utf8;
set character_set_connection=utf8;
set character_set_database=utf8;
set character_set_results=utf8;
set character_set_server=utf8;
set character_set_system=utf8;
set collation_connection=utf8;
set collation_database=utf8;
set collation_server=utf8;
-- 查看mysql字符集
show variables like 'collation_%';
show variables like '%char%';
-- 修改密码
UPDATE user SET password=PASSWORD('123456') WHERE user='root';
FLUSH PRIVILEGES;
mysql相关命令
最新推荐文章于 2024-08-09 21:25:57 发布