Home >Backend Development >PHP Tutorial >升级到MySQL 5.0.17一定遇到的四个问题_PHP
升级到MySQL 5.0.17一定遇到的四个问题_PHP
- WBOYOriginal
- 2016-06-01 12:29:39992browse
1 中文问题
在使用MySQL实例配置工具的使用，将使用的字符集设置为GBK
2 密码问题：安装时设置的密码使用phpMyAdmin访问时不能用
mysql> SET PASSWORD FOR
-> 'root'@'localhost' = OLD_PASSWORD('root');
3 字段严格检查的问题
在实例配置工具中将Enable Strict Mode去掉
4 phpMyAdmin乱码问题
Language :Chinese simplified(zh-utf-8)
MySQL 连接校对:gbk_chinese_ci
新建立数据库和varchar等字段时候的整理为：gbk_chinese_ci
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：构架Linux下的PHP MySQL开发环境_PHPNext article：三招针对PHP木马攻击的易行防御之道_PHP