Mysql, Apps And Connections

[flatpad]

Hi everyone, and thanks to you/those that have put these services online.

Although web design and hosting hold few secrets for me, MySql, app creation and hosting them is another ball game, i don't know jack....

So hopefully somewhere somebody can help me understand a few things!?

I have a MySql chat made in Visual basic on visual studio 2015, it works fine locally.

So far I have imported my DB through PhpMyAdmin and the tables are set, before i uploaded i noticed it says 'Host: 127.0.0.1 do i need to change this before re-uploading it?

I have already manage to upload this to my ISP MySql but they don't allow remote access.

Within my App it is asking for connection info as follows: On my ISP services i received the info by email, here i am a little unsure, although my DB name is obvious

server=SOMETHING.heliohost.org; user id=MYHELIO USER ID; password=My HELIO PASSWORD; database=My DB name

What do i need to change the bold red info with. Do i use my helios user name and password?

I have tried with this so far:
server=johnny.heliohost.org; user id=MyHelioUserID; password=MyHelioPassword; database=db_MyDataBaseName"

and get this message error:
Authentication to host 'johnny.heliohost.org' for user 'MyHelioUserID' using method 'mysql_native_password' failed with message: Access denied for user 'MyHelioUserID'@'%' to database 'db_MyDataBaseName'

The green part looks like i am using the wrong password

 

 

I forgot to mention, my app needs the user to create an account before using it which is stored in the DB, as i said this works locally
thanks in advance.

OK after a short while i realized that i had forgotten something
So if anyone else needs it/

BEFORE
server=johnny.heliohost.org; user id=MyHelioUserID; password=MyHelioPassword; database=db_MyDataBaseName"

 

AFTER

server=johnny.heliohost.org; user id=MyHelioUserID; password=MyHelioPassword; database=MyHelioUserID_db_MyDataBaseName"

Thanks again for the services i will put your name forward ;-)

Edited June 27, 2017 by flatpad

[cmh]

Hello. I connected to Johnny with this code

 Params.Add('server=64.62.211.131');
      Params.Database:='db_name';
      Params.UserName:='username';
      Params.Password:='SUPERPASSWORD';
 

Also, in Cpanel .> Remote Mysql > add % for remote access from any ip

Edited July 4, 2017 by cmh2