使用php无法在数据库上读取或写入(Can't read or write on database using php)

使用php无法在数据库上读取或写入(Can't read or write on database using php)

我正在开发一个网站，所以我将我的数据存储在db4free.net - 免费在线数据库中，但我无法读取或写入或者选择数据库（错误：查询错误：。对用户''拒绝SELECT命令表'first'的'localhost'）但是我尝试使用heidiSQL -desktop应用程序来管理网络上的数据库 - 它工作正常，我可以选择，插入和删除。 这是我的PHP代码：

$conn=mysqli_connect("db4free.net:3306","usr","pass"); $sql = "select * from test1.first"; $result = mysql_query($sql) or die ("Error in query: $query. ".mysql_error());

有什么帮助吗？

i'm developing a website so i store my data in db4free.net -free online database-, but i can't read or write or eveen select the database (error: Error in query: . SELECT command denied to user ''@'localhost' for table 'first') but i tryed heidiSQL -desktop application to manage DBs over networks- it worked correctly and i can select,insert and delete. this is my php code:

$conn=mysqli_connect("db4free.net:3306","usr","pass"); $sql = "select * from test1.first"; $result = mysql_query($sql) or die ("Error in query: $query. ".mysql_error());

any help please ?

最满意答案

这对我有用：

$conn=mysql_connect("db4free.net","usr","pass",3306);

This worked for me:

$conn=mysql_connect("db4free.net","usr","pass",3306);