Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\login\login.php on line 13
Couldn't connect to database
if ($username&&$password)
{
$connect = mysql_connect("localhost", "root", "") or die ("Couldn't connect to database");
mysql_select_db("member") or die ("Couldn't find database");
$quiery = mysql_query("SELECT * FROM login WHERE username='$username'");
$numrows = mysql_num_rows($query);
if($numrows !=0)
{
while ($row = mysql_fetch_assoc($query))
{
$dbusername = $row['username'];
$dbpassword = $row['password'];
}
if ($username==$dbusername&&$password==$dbpassword)
{
echo "Login successful. <a href='membersarea.php'>Click here to enter the members are</a>";
$_SESSION['username']=$dbusername;
}
else
echo "Invalid Password!";
}
else
die ("That username doesn't exist!");
}
else
die ("Please re-enter username & password.");
你现在的问题是你得root有放password,但是你得php mysqlconnect没放。建议你add new user
leon_lcl 发表于 2012-2-27 09:23 PM
我的phpmyadmin 的 username=root..password=123456....
而如果我在highlight那边放123456..
$connect = mysql_connect("localhost", "root", "123456") or die ("Couldn't connect to database");
那么它就会变Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) 而不是 NO 了...
如果要add new user...
那么 username 我要换别的 还是可以继续放 root??
HOST 是不是选 local??
password就不要放??作者: htuomrev 时间: 2012-2-27 09:43 PM
add new user了过后直接用新username和密码连接数据库就可以了。
还有你的root不能够访问,如果要继续用root按照楼上朋友的方法去设置,不然就add new user。作者: UWai 时间: 2012-2-27 09:48 PM
add new user了过后直接用新username和密码连接数据库就可以了。
还有你的root不能够访问,如果要继续用ro ...
htuomrev 发表于 2012-2-27 09:43 PM
如果不要add new user...
我的phpmyadmin 的 username=root..password=123456....
我在highlight那边放123456..
$connect = mysql_connect("localhost", "root", "123456") or die ("Couldn't connect to database");
是不是这样???
可是wor...
我放了123456后..
那么它就会变Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) 而不是 NO 了...