MySQL Forums
Forum List  »  PHP

FIXED
Posted by: Sebastian Auer
Date: February 17, 2014 04:06AM

Hi Guys,

after talking with the external provider we found the problem. You can choose in the setting for the db rights between "select all" or checkbox for "SELECT; INSERT; ...".

And no idea why, but when you choose "SELECT ALL" it is not working, if you choose everys single right with the checkbox then it works.

but after fixing the problem, I'm still wondered why the error msg from mysql says "SELECT command denied to user 'p168417d3'@'109.12.01.12'" when it should say:
"SELECT command denied to user 'p168417d3'@'www.externalserver.com'".

Thank for your help, I came up to this solution because of your hint with the "SHOW VARIABLES LIKE 'skip%';" because that worked without any problems and then I was 100% sure that I'm on the right server. :)

greetings, sebastian

Options: ReplyQuote


Subject
Written By
Posted
FIXED
February 17, 2014 04:06AM
February 17, 2014 12:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.