关于MYSQL和PHP的安装
qyxc 2002-05-17 09:17:49 我用的是apache+php+mysql
具体是:
apache_1.3.24-win32-x86-no_src.exe
php-4.2.1-installer.exe
MYSQL4.0A
操作系统是win2000PRO
我已经能让apache浏览php3格式的网页了
我用
<? phpinfo(); ?>
生成的info.php3文件
在浏览器出现的结果
我主要是想问您一下:
我在mysql\bin\下用
mysqladmin -u root create mydb
不能创建数据库
出现提示:
mysqladmin: Unknown command: 'mydb'
只能用:
mysqladmin cteate mydb
来创建数据库。
创建数据库后,建立test.php3
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
printf("First Name: %s<>\n", mysql_result($result,0,"first"));
printf("Last Name: %s<>\n", mysql_result($result,0,"last"));
printf("Address: %s<>\n", mysql_result($result,0,"address"));
printf("Position: %s<>\n", mysql_result($result,0,"position"));
?>
在浏览器浏览出现以下结果:
Warning: Access denied for user: 'root@127.0.0.1' (Using password: NO) in d:\php\apache\htdocs\test.php3 on line 7
Warning: MySQL Connection Failed: Access denied for user: 'root@127.0.0.1' (Using password: NO) in d:\php\apache\htdocs\test.php3 on line 7
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\php\apache\htdocs\test.php3 on line 9
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\php\apache\htdocs\test.php3 on line 11
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:\php\apache\htdocs\test.php3 on line 13
First Name: <>
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:\php\apache\htdocs\test.php3 on line 15
Last Name: <>
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:\php\apache\htdocs\test.php3 on line 17
Address: <>
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:\php\apache\htdocs\test.php3 on line 19
Position: <>
不知道是什么意思,您能告诉我怎么让这些东西顺利运行吗??
谢谢!!