WebFaction
Community site: login faq
0
1

I've created a database with the webfaction control panel and restored via sql script. When I tested my application i got this error:

SELECT command denied to user 'orinoquia_quizno'@'localhost' for table 'productos'

the select command i'm using is something like this:

SELECT
    `tbl1`.`producto_id`,
    `tbl1`.`producto_nombre`,
    `tbl1`.`producto_descripcion`,
    `tbl1`.`producto_prioridad`,
    `tbl1`.`categoria_id`,
    `tbl2`.`categoria_titulo`
    FROM `orinoqui_quiznos`.`productos` as tbl1
    INNER JOIN `categorias` as tbl2 on tbl1.`categoria_id` = tbl2.`categoria_id`
    WHERE tbl1.producto_id = {$_REQUEST["id"]};

The thing is when I make a simple SELECT (ie: SELECT * FROM producto) everything works fine, so I'm guessing is something that have to do with the INNER JOIN command.

When I tried to run the query in mysql Workbench it says:

Error Code: 1044
Access denied for user 'orinoquia\_quizno'@'localhost' to database 'orinoquia\_quizno'
GRANT ALL ON orinoquia_quizno.* TO orinoquia_quizno@localhost

but the user im using can't grant permissions on itself, how can I resolve this?

asked 21 Jul '11, 10:53

marcoslhc
2113
accept rate: 0%

edited 21 Jul '11, 10:58


Oh!, my bad!

the problem was the name of the tables. It should be orinoquia_quizno instead of orinoqui_quiznos

permanent link

answered 21 Jul '11, 11:12

marcoslhc
2113
accept rate: 0%

edited 21 Jul '11, 11:13

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×262
×168
×64
×14

question asked: 21 Jul '11, 10:53

question was seen: 4,792 times

last updated: 21 Jul '11, 11:13

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM