Jump to content

Search the Community

Showing results for tags 'remote mysql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General Discussion
    • Website Management and Coding
    • Technology and the Internet
    • Philosophy, Politics, and Science
    • Art and Entertainment
    • Other Discussion
  • HelioHost
    • Questions
    • Customer Service
    • How You Can Help
  • HelioNet
    • News
    • Contact HelioNet

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 3 results

  1. Hi, I have been trying to connect to my MySQL database added through cPanel with PHP. It turned out that the connection was successful, but it cannot execute any commands. I tried to execute the command in my local IDE (I am using PhpStorm), and it succeeded. I used the same configuration with mysqli, but it doesn't work. In connect.php: <?php $dbServername = "ricky.heliohost.org:3306"; $dbUsername = "username"; $dbPassword = "password"; $dbName = "test"; $conn = new mysqli($dbServername, $dbUsername, $dbPassword, $dbName); if ($conn->connect_error) { die("Connection Error: " . $conn->connect_error); } echo "Connection successful"; $stmt = $conn->prepare("SELECT * FROM test"); $stmt->execute(); The output is just "Connection successful"; it does not execute the SELECT statement. Can anyone please help me? Thank you very much!
  2. Hi guys. I was trying to make my c# program to access mysql database with stevie.heliohost.org but it keeps showing error. Please help me with it. string cs = "host=stevie.heliohost.org;database=***;uid=***;password=*** "; is there anything wrong with this line? I have hide my database, uid and password for security purpose. The error im getting is as below: Error: MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open()
  3. hi guys, I've been wondering why can't I connect my program to remote mysql? I know already about the "%" thing. I've already added that % in my access host. My program is fully working, it can connect to my localhost database, and last year, I successfully connected my program to any hosting sites that allows remote-mysql. here is my code: MySqlConnection.ConnectionString = "database=1269017_rafdb;server=fdb4.awardspace.com;port=3306;user id=1269017_rafdb;password=0q0EVEBGNG" note: sorry I have to remove the code tags, code is getting messy if it is inserted between code tags. do I have to add port? my url in my homepage is: "http://stevie.heliohost.org:2082/frontend/x3/index.html" so I guess my server would be stevie.heliohost.org and port is 2082 (just a guess). is my server correct? please! looking forward to your answer..I already tried many hosting sites, and none of them works!
×
×
  • Create New...