SQL Query Object: Advanced Mode - Easy Builder Pro

[@vilhelmsbalodis7637]

I followed the tutorial to the "t", and I have come across a problem on Easybuilder Pro side where it shows status "Disconnected" and reason for that is that "Database blocks unauthorized connection". Do you have a solution for this, because I couldn't find anyone on Internet?

[@WeintekUSATeam.0]

Hi Vilhelms, I believe that this may be due to invalid user permissions. Please ensure that the user account that you are using to access the server has the correct permissions set within the "Users and privileges" tab of MySQL. To do this, open "Users and privileges" then ensure that "DBA" is enabled within the "Administrative roles" tab.

[@trungnguyenquang3002]

I have followed this video closely , but unsuccessful . I can not cannect mySQL with easybuild . it doesnt have the data in cmtviewer when I simulation. Please help me

[@WeintekUSAInc]

Hi @trungnguyenquang3002, When using a local MySQL server, this issue may occur when the PC hosting the SQL server has blocked the incoming connection. To resolve this, please add an exception to the PC's firewall so that the incoming client connection will be allowed.

[@rizwanmahmood7350]

That is very helpful , Please send me update and delete query example project . i have tried but UPDATE is not working well i have used this query for update. UPDTAE TEST1 SET TAG1 = '${1}' where TAG1='${1}' TEST1 is my SQL table and TAG1 is column name