How to connect DB node to a local server?

Hello. i moved my database on my local server sinology. I don't know how to set DB node. because nodered is on a raspberry and database is with an other ip. So if i set localhost it doesnt work. if i set server ip like http// 192.168.86.78 with port 3306 it doesnt work. what can i set ?
thanks

if you use MySQL db then there is no problem.
mysql command grant it will help you ..

mysql> grant all on *.* to yourDbID identified by 'yourDbPasswd';
mysql> flush privileges;

it was something like that. i had to accord privilege to my raspberry .
Thanks for help