21,887
社区成员
发帖
与我相关
我的任务
分享菜鸟问题比较多，大家不要介意：PHP和MySQL貌似不能连接
我写了2个文件：
1：vote.html
<!DOCTYPE HEML PUBLIC "-//W3C//DTD HTML 4.0//EM">
<!- php/vote/vote.html ->
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1" />
<title>MySQL-poll</title>
</head>
<body>
<h2>MySQL-poll</h2>
<form method="post" action=results.php">
<p><input type="submit" name="submitbutton" value="OK" /></p>
</form>
<p>Go directly to the <a href="results.php">result</a>.</p>
</body>
</html>
2：results.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<!- php/vote/results.php ->
<html>
<head>
<meta http-equiv = "Content-Type"
content = "text/html; charset=iso-8859-1" />
<title>Survey Result</title>
</head>
<body>
<?php
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqlpasswd = "zaq1";
$mysqldbname = "test_vote";
$link = @mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd);
if($link == FALSE)
{
echo "<p><b>Connect Fail</b></p></body></html>
\n";
exit();
}
?>
</body>
</html>
用户名，密码都没错，数据库test_vote也建了，MySQL也正常启动了，可是结果如下：
1:点击OK结果：
Forbidden
You don't have permission to access /ing/3/results.php" on this server.
--------------------------------------------------------------------------------
Apache/1.3.31 Server at AMD.func.fzu.edu.cn Port 80
2：点击result结果：
Connect Fail
这是怎么回事？
1：vote.html
<!DOCTYPE HEML PUBLIC "-//W3C//DTD HTML 4.0//EM">
<!- php/vote/vote.html ->
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1" />
<title>MySQL-poll</title>
</head>
<body>
<h2>MySQL-poll</h2>
<form method="post" action=results.php">
<p><input type="submit" name="submitbutton" value="OK" /></p>
</form>
<p>Go directly to the <a href="results.php">result</a>.</p>
</body>
</html>
2：results.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<!- php/vote/results.php ->
<html>
<head>
<meta http-equiv = "Content-Type"
content = "text/html; charset=iso-8859-1" />
<title>Survey Result</title>
</head>
<body>
<?php
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqlpasswd = "zaq1";
$mysqldbname = "test_vote";
$link = @mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd);
if($link == FALSE)
{
echo "<p><b>Connect Fail</b></p></body></html>
\n";
exit();
}
?>
</body>
</html>
用户名，密码都没错，数据库test_vote也建了，MySQL也正常启动了，可是结果如下：
1:点击OK结果：
Forbidden
You don't have permission to access /ing/3/results.php" on this server.
--------------------------------------------------------------------------------
Apache/1.3.31 Server at AMD.func.fzu.edu.cn Port 80
2：点击result结果：
Connect Fail
这是怎么回事？
...全文
请发表友善的回复…
发表回复
ciaky 2007-04-17
- 打赏
- 举报
要用正斜杠。
wdyouling888 2007-04-17
- 打赏
- 举报
我删了2个，一个system32下的，一个windows下的，重启apache时出现下面错误：
PHP Startup: Unable to load dynamic library 'F:/study/PHP/ext\php_mysql.dll' - 找不到指定的程序。
可是'F:/study/PHP/ext\php_mysql.dll' 是有的。
PHP Startup: Unable to load dynamic library 'F:/study/PHP/ext\php_mysql.dll' - 找不到指定的程序。
可是'F:/study/PHP/ext\php_mysql.dll' 是有的。
mrshelly 2007-04-17
- 打赏
- 举报
查找电脑里所有的 libmysql.dll 除你用的PHP的目录下的.其余全部删除.尤其是 %System% 下的.
然后 继续.
注意你是否是启动你指定的MYSQL SERVER.
............
环境问题.
然后 继续.
注意你是否是启动你指定的MYSQL SERVER.
............
环境问题.
wdyouling888 2007-04-17
- 打赏
- 举报
libmysql.dll的版本号在哪看？
我用它们运行不用连接mysql的网页可以通过
我用它们运行不用连接mysql的网页可以通过
mrshelly 2007-04-17
- 打赏
- 举报
这两个版本的连接不会出现 上面的提示.
注意 libmysql.dll 文件的版本号.
你的环境并不是你给出的环境.
注意 libmysql.dll 文件的版本号.
你的环境并不是你给出的环境.
wdyouling888 2007-04-17
- 打赏
- 举报
mysql 版本为5.0.18-nt
php为5.0.0
php为5.0.0
mrshelly 2007-04-17
- 打赏
- 举报
MySQL 版本号,
PHP版本号.
先GOOGLE authentication protocol requested by server;
PHP版本号.
先GOOGLE authentication protocol requested by server;
wdyouling888 2007-04-17
- 打赏
- 举报
我按楼上的改了，结果变成这样：
Survey Result
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in f:\study\apache group\Apache\htdocs\ing\3\results.php on line 16
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in f:\study\apache group\Apache\htdocs\ing\3\results.php on line 17
Connect Fail
Survey Result
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in f:\study\apache group\Apache\htdocs\ing\3\results.php on line 16
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in f:\study\apache group\Apache\htdocs\ing\3\results.php on line 17
Connect Fail
my_web 2007-04-17
- 打赏
- 举报
<?php
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqlpasswd = "zaq1";
$mysqldbname = "test_vote";
$link = mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd);
mysql_select_db($mysqldbname,$link);
if($link == FALSE)
{
echo "<p><b>Connect Fail</b></p></body></html>
\n";
exit();
}
?>
</body>
</html>
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqlpasswd = "zaq1";
$mysqldbname = "test_vote";
$link = mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd);
mysql_select_db($mysqldbname,$link);
if($link == FALSE)
{
echo "<p><b>Connect Fail</b></p></body></html>
\n";
exit();
}
?>
</body>
</html>
my_web 2007-04-17
- 打赏
- 举报
<?php
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqlpasswd = "zaq1";
$mysqldbname = "test_vote";
$link = @mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd);
mysql_select_db($mysqldbname,$link);
if($link == FALSE)
{
echo "<p><b>Connect Fail</b></p></body></html>
\n";
exit();
}
?>
</body>
</html>
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqlpasswd = "zaq1";
$mysqldbname = "test_vote";
$link = @mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd);
mysql_select_db($mysqldbname,$link);
if($link == FALSE)
{
echo "<p><b>Connect Fail</b></p></body></html>
\n";
exit();
}
?>
</body>
</html>
