mysql_select_db('peng', $conn) or die ('Can\'t use peng : ' . mysql_error());运行的结果: yes Can't use peng : Access denied for user: '@localhost' to database 'peng'
Can't use peng : Access denied for user: '@localhost' to database 'peng' 不是很明显吗?你并没有给用户名呀你这样测试 $conn = mysql_connect();
#连接数据库# $conn = mysql_connect($url,$user,$passwd); echo "the user is ==>".$user."<br>"; if($conn) echo "yes"; else echo "no";
mysql_select_db('peng', $conn) or die ('Can\'t use peng : ' . mysql_error()); 运行结果: the user is ==>root yesCan't use peng : Access denied for user: '@localhost' to database 'peng'我的用户名字已经输出来了.是root.怎么回事呢..
这样就能关闭安全模式了,重起web服务器,就ok了。
if($conn)
echo "yes";
else
echo "no";
mysql_select_db('peng', $conn) or die ('Can\'t use peng : ' . mysql_error());运行的结果:
yes
Can't use peng : Access denied for user: '@localhost' to database 'peng'
mysql_select_db($db_name, $conn)
yes
Can't use peng : Access denied for user: '@localhost' to database 'peng'
就可以了,一定可以。
不是很明显吗?你并没有给用户名呀你这样测试
$conn = mysql_connect();
$conn = mysql_connect($url,$user,$passwd);
echo "the user is ==>".$user."<br>";
if($conn)
echo "yes";
else
echo "no";
mysql_select_db('peng', $conn) or die ('Can\'t use peng : ' . mysql_error());
运行结果:
the user is ==>root
yesCan't use peng : Access denied for user: '@localhost' to database 'peng'我的用户名字已经输出来了.是root.怎么回事呢..
缺少帐号
添加一个新用户,用户名:test 密码:123
GRANT ALL PRIVILEGES ON *.* TO test@'%' IDENTIFIED BY '123'
试试用这个用户名和密码,URL只要添你本机的IP就可以了。
还有就是root帐号是否设置为不能从外部(非本机)访问数据库?