Accdss denied for user:'[email protected]'(using password:yes)
Run following command on sql (use root user)
grant all on you_db.* to [email protected] identified by 'your_password';
Run following command on sql (use root user)
grant all on you_db.* to [email protected] identified by 'your_password';
权限问题？能不能具体点呢？谢谢...
怎么解决呢？
...
<form method="POST" action="check.php" name="LoginForm">
...
用户名：<input type="text" name="username" size="15">
...
密 码：<input type="password" name="password" size="15">
...
<td vAlign=bottom width="100%" <div align="right"><input name="image" type=image src="image/dl.gif" width="59" height="23"></div></td> //登陆图片
...
▄◣check.php
<?php
session_start();
if($_POST[username]=="")
{
echo "<script language=javascript>alert('请输入用户名');history.go(-1)</script>";
...
echo "<script language=javascript>alert('请输入密码');history.go(-1)</script>";
exit;
}
else
{
include ("include/conn.php"); //▄◣conn.php为连接数据库文件
$result=$DB->query("select zb_userid,zb_user,zb_password,zb_unit from user
where zb_user='$_POST[username]'",$dbbase);
if($result)
{
session_register ("unit");
$name=$member[zb_user];
....
$member[zb_userid]=$row[0];
global $name;
if($member[zb_password]!=$_POST[password])
{
echo "<script language=javascript>alert('用户和密码错误');history.go(-1)</script>";
exit;
}
else
...
echo "<script language=javascript>alert('无此用户');history.go(-1)</script>";
exit;
}
}
?>▄tx.php文件代码：
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_tx = "li";
$database_tx = "zbgl";
$username_tx = "root";
$password_tx = "root";
$tx = mysql_pconnect($hostname_tx, $username_tx, $password_tx) or die(mysql_error()); //line 9
?>
▄◣right.php 部分代码 为登陆进去的右下框架页，即出错1页面
<?php session_start();?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>信息上报</title>
</head><body bgcolor="#FFeab5">
<?php require_once('Connections/tx.php'); ?>
<?php
mysql_select_db($database_tx, $tx);
$query_bjr = "SELECT zb_bjr FROM bjr";
$bjr = mysql_query($query_bjr, $tx) or die(mysql_error());
$row_bjr = mysql_fetch_assoc($bjr);
$totalRows_bjr = mysql_num_rows($bjr);mysql_select_db($database_tx, $tx);
$query_jfr = "SELECT zb_jfr FROM jfr";
$jfr = mysql_query($query_jfr, $tx) or die(mysql_error());
$row_jfr = mysql_fetch_assoc($jfr);
$totalRows_jfr = mysql_num_rows($jfr);mysql_select_db($database_tx, $tx);
$query_mj = "SELECT zb_mj FROM mj";
$mj = mysql_query($query_mj, $tx) or die(mysql_error());
$row_mj = mysql_fetch_assoc($mj);
$totalRows_mj = mysql_num_rows($mj);function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
$database_tx = "zbgl";
$username_tx = "root";
$password_tx = "root";
$tx = mysql_pconnect($hostname_tx, $username_tx, $password_tx) or die(mysql_error()); //line 9Accdss denied for user:'[email protected]'(using password:yes)你用root连怎么会出现"zbglroo@"的错误信息？是不是自己哪儿弄错了？
改tx.php中的
$hostname_tx = "localhost"; //原先你这边是li，这一个是要连接数据库的机器名或IP
$database_tx = "zbgl"; //这个是你那套php程序所使用mysql数据库的库名
$username_tx = "root"; //这边使用你那套php程序连接mysql数据库的用户名
$password_tx = "root"; //这边使用你那套php程序连接mysql数据库的密码当然用root连接mysql数据库可以，不过有点危险。