Search the Community
Showing results for tags 'remote mysql'.
Found 3 results
-
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!
-
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() -
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!
