user_15311112的博客

create database: create database test character set ‘gbk’ collate ‘gbk_chinese_ci’; create database test character set ‘utf8’ collate ‘utf8_general_ci’;

方便查找，记下网址：https://www.jb51.net/article/138379.htmhttps://blog.youkuaiyun.com/dreamfly88/article/details/72885897Tomcat日志报如下提示，也能解决：User does not have access to metadata required to determine stored proc...

my.ini文件中： [client] defaulst-character-set=utf8 [mysqld] character-set-server=utf8命令窗口执行：show variables like ‘%char%’;结 果如下： +————————–+——– | Variable_name | Value +————————–+——– ...

备份数据库： mysqldump -h hostname -P port -u username -p dbname table1 table2 … > C:\test.sqlhttps://www.cnblogs.com/shynshyn/p/7875246.html使用备份的文件来还原数据库： mysql -hlocalhost -P3306 -uroot -p dbnam...