connect to cpanel mysql db from zennoposter

[Saeedgh837]

hi friends
i am trying to connect to my Cpanel host's DB from my computer with zennoposter database connector but i can not make it work
already tried these:
1. install .net connector to my pc
2. allow remote MySQL access on Cpanel settings
3. looked up in internet for solution but all was telling me to addthe ip to remote mysql

actually, I have made a website for my bot so i can monitor my zennoposter tasks and tables all I need is to have a database over local so both my website and zenno can have access to it.

can someone help me to fix my issue on the top?
or offer me another way to store data in a database in cloud...



thanks so much
best regards.

 

[nicanil]

Use Database action and it's "Connection manager" to create connection string.

Спойлер: Скриншот

1. MySQL server's IP address.
2. MySQL server's user name.
3. MySQL server's password
4. Database name
5. Test connection to see if you entered proper data

 

[Saeedgh837]

Use Database action and it's "Connection manager" to create connection string.

Спойлер: Скриншот

1. MySQL server's IP address.
2. MySQL server's user name.
3. MySQL server's password
4. Database name
5. Test connection to see if you entered proper data
Посмотреть вложение 81335

i got it working in mysql workbench but now i tried in zenno and it shows me this error.

if i use localhost or 127.0.0.1 it tries to connect but if i put my host o server address it gives error.

 

[Saeedgh837]

got the answer from here

https://zennolab.com/discussion/threads/ne-mogu-podkljuchitsja-k-bd-mysql-server.72757/