Jump to content

flatpad

Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by flatpad

  1. 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 ;-)
×
×
  • Create New...