(如果不用wampserver的集成环境的话,可以参考如下文档去逐个安装)
http://www.jb51.net/article/22895.htm
Windows下:
一、phpmyadminn链接数据库失败:登陆localhost/phpmyadmin#1045 - Access denied for user 'root'@'localhost' (using password: NO)
DIY:
(1) 去C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php.修改php配置文件中的
config.inc.php,修改密码和用户
$cfg['Servers'][$i]['password'] = '****';(****是你的密码)
$cfg['Servers'][$i]['user'] = 'root';
(2)去C:\wamp\apps\phpmyadmin3.2.0.1\libraries\config.default.php中将语句
$cfg['Servers'][$i]['extension'] = 'mysql';前的分号去掉。
*******终极boss(美学上不推荐):重装一遍(wamp),记住保留自己写的文件。
二、将网页上的表单内容导入数据库失败
1、insert into 中的sql语句中包含了php+mysql的关键字,
DIY:这就需要我们把数据表里有冲突的内容项名称该掉。
关键字见:
ADD | ALL | ALTER |
ANALYZE | AND | AS |
ASC | ASENSITIVE | BEFORE |
BETWEEN | BIGINT | BINARY |
BLOB | BOTH | BY |
CALL | CASCADE | CASE |
CHANGE | CHAR | CHARACTER |
CHECK | COLLATE | COLUMN |
CONDITION | CONNECTION | CONSTRAINT |
CONTINUE | CONVERT | CREATE |
CROSS | CURRENT_DATE | CURRENT_TIME |
CURRENT_TIMESTAMP | CURRENT_USER | CURSOR |
DATABASE | DATABASES | DAY_HOUR |
DAY_MICROSECOND |