user access denied error in mysql connection

[Anonymous]

Hi

I'm facing very bad situation in Mysql 5.7
I'm having username--> pop and password --> pop with database name "Home"
When I connect from workbench..its works fine.
When I connect through tmysqlinputconnection (adding manually credentials in component) it works.
Problem is, when I try to connect the tmysqlinputconnection  with conext parameters where values are coming from file
Shows error like this-----> Access denied for user 'pop'@'localhost' (using password: YES)
May I know please from where its coming ...?
Thanks in advance !!

[Anonymous]

If it works with hard-coded credentials but it does not work with context variables, then your context variables are not getting set correctly.
I'd try dumping them just before the MySQL connection, to see what is going on.
tContextDump->tLogRow
There are some instances where context does not get synchronized correctly, so it may be worth trying to call context.synchronizeContext() after loading your context to see if this makes a difference; but I'd try dumping the context first.

[Anonymous]

I've just used that, all values are coming correctly through tcontextdump.
Any other suggestion please ? 

[Anonymous]

Did you try the synchronize?
Post some screenshots of your context dump and tMySQLConnection

[Anonymous]

tfileinputdelimited(context parameter file)------>tcontextload
|
on sub job ok
|
tmysqlconnection

When I print variables, it comes perfectly ..

could you please tell me how to use context.synchronize()?

[Anonymous]

Add a tJava before tMySQLConnection and insert the statement

[Anonymous]

tfileinputdelimited(context parameter file)------>tcontextload
|
on sub job ok
|
tjava (context.synchronizeContext(); )
|
on sub job ok
|
tmysqlconnection


still same erro....

[Anonymous]

I think you need to post the screenshots that I suggested

[jay6]

Hi,

I seem to be having the same issue as ashish123. I'm using Talend 6.2. I have a very similair job setup but without context parameters and am trying to connect to a remote DB. 
Did anyone find a solution to the issue?

Thanks
Jay

[vapukov]

jay_m wrote:
Hi,

I seem to be having the same issue as ashish123. I'm using Talend 6.2. I have a very similair job setup but without context parameters and am trying to connect to a remote DB. 
Did anyone find a solution to the issue?

Thanks
Jay

There no errors - all work perfect
so the question sam as for ashish123 - please share pictures (and settings and error)