 2个人参与点评 这几天在尝试安装mambo 4.53h版, 由于我的数据库是mysq4.1以上版本,并且设定的字符集是UTF8 。在尝试安装了几次后发现以下几种情况: 1. 将数据库设置为 latin1 , 不修改任何文件,在安装时无论选择gb2312 还是utf8,都可以完成安装,并且网页显示正常,但是通过phpmyadmin看数据表时发现,里面所有中文全部为乱码,也就是说,通过latin1字符集保存,
 1个人参与点评 If you have set a root password, but forgot what it was, you can set a new password with the following procedure: 1. Take down the mysqld server by sending a kill (not kill-9) to the mysqld server. T
 1个人参与点评 By default, MySQL database server remote access disabled forsecurity reasons. However, some time you need to provide the remoteaccess to database server from home or from web server. Step # 1: Login
 2个人参与点评 从MySQL 4.1开始引入的多语言支持确实很棒,而且一些特性已经超过了其他的数据库系统。不过我在测试过程中发现使用适用于MySQL 4.1之前的PHP语句操作MySQL数据库会造成乱码,即使是设置过了表字符集也是如此。我读了一下新的MySQL在线手册中第十章 "Character Set Support"后终于找到了解决方法并测试通过。 MySQL 4.1的字符集支持(Character
 2个人参与点评 添加用户 & 用户授权: [code:1:e74e94391a]mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
 2个人参与点评 Assume the base folder is /srv/ Apache Installation More apache configuration http://httpd.apache.org/docs/2.2/programs/configure.html#configurationoptions [code:1:9273ec47e2]./configure --p
 1个人参与点评 MySQL has a feature that allows you to log slow running queries to a file. To enable you just need to add some lines to your my.cnf file, and restart. Add the following: log-slow-queries = /var/log
 1个人参与点评 简要说一下mysql4.1以后的问题 第一:mysql4.1的存储方式已经是utf8的了。。也就是说他的文件编码是utf8格式,我们不需要担心会有存储不了的字符 第二:mysql服务器需要以一种编码方式来启动,设定连接(通讯)过来的字符编码是什么,就是所谓的我们的交流语言 第三:mysql的client端,需要设定一种编码去和mysql的服务器端通讯,也是交流语言 那么如何解决乱码的问
|