Search the Community

Hi guys, I'm new user of Heliohost who yesteday made MySQL database on Johnny server, which is needed for small university's project, this means I'm using remote connection [from SQLDeveloper actually]. Connection, making tables went well, but problems has begun when I tried to fill some small data into it. Almost every single time, when I try to look into table f.e. to see what columns I've got in there or just to check if insert query was made in the way I would like it to I receive an error message: After that I get connection reset. What I should to manage with thie case? Looking forward for your help!

I have the following configuration to connect to the database: $db_username = 'user=myuser'; $db_password = 'password=mypass'; $db_name = 'dbname=test'; $db_host = 'host=localhost'; $db = pg_connect("$db_host $db_username $db_password $db_name"); $query = "SELECT * FROM cities"; $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . "<br/>"; echo pg_last_error(); exit(); } $myrow = pg_fetch_assoc($result); $city = $myrow[city]; echo $city; The previous code works and it prints the name of the city in the table cities. Now If I try with the same but another table(Menu) which also have the field city I get the following error: Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation menu in /home1/user/public_html/index.php on line 9 Problem with query SELECT * FROM menu ERROR: permission denied for relation menu Both tables are under the same database (test) which was created by the same user. I don't know if I need to grant access to each table to the user and how or why am I getting this error. (When I run this in my computer it works but once I uploaded to the web that the error I'm getting) Any help would be highly appreciated.

It looks like after this 'A Dns Entry For Professionalserver.tk Already Exists' problem, I don't have now a capacity to upload my "phpDolphin.sql" file using the import function available in MySQL database.. This is what happened after uploading that SQL file: Can somebody fix my new issue? This problem is not existed when I'm in Johnny server. Okay here is what happening when I Check DB: MySQL Databases Checking Database mbdungo_phpdolphin is now being checked. mbdungo_phpdolphin.admin Error : Table 'mbdungo_phpdolphin.admin' doesn't exist status : Operation failed Check Complete