resparkman1
-
Posts
6 -
Joined
-
Last visited
Posts posted by resparkman1
-
-
On 3/23/2023 at 7:40 PM, wolstech said:
I just want to clarify, if I select the option 'Allow remote connections from any host' does that mean I can now access the mysql databse from any machine or IP address with the right credentials?
-
1 hour ago, wolstech said:
Thanks a lot for answering, another question is that, is this remote access from my local machine to the mysql datbase encrypted? If no, are there ways where I can get and incorporate SSL/TLS certificate to the code to make the connection or network traffic between my Python code and the MySQL database encrypted ?
-
14 minutes ago, wolstech said:
I'm assuming you actually changed the username in the code? Your SQL users will all start with resparkman1_ , so the username shown above would never work.
Host name for remote mysql is Johnny.heliohost.org, port 3306.
Thank you so much it now works, regarding the remote access to the database. I tried following one of the discussions here (that is dated 5 years ago) but I cannot seem to find in the plesk control panel where I can set the remote access panel to allow my IP address to remotely connect to my database.
-
Hello I am new to heliohost, I just deployed my php website and mysql database, and created user for the database, then replace the credentials in my codes so that my website can access the database properly. However I got this error; connection failed:Access denied for user 'root_admin'@'%' to database 'mydb' , even though I already checked that all the credentials are correct. Any help would be greatly appreciated, and would reply if you need any further information. I am also planning to remotely access the mysql database via python code on my local machine using the mysql.connector python library to read and write records. This is the code I use;
import mysql.connector
connection = mysql.connector.connect(
host="johnny.heliohost.org",
user="root_admin",
password="****",
database="mydb"
)cursor = connection.cursor()
cursor.execute("SELECT * FROM accounts")results = cursor.fetchall()
I have viewed answers about this and tried to follow them but those answers seems a little outdated, thus, can you also tell me how can I remotely access my mysql database via python code on my local machine? -
Hello I am new to heliohost, I just deployed my php website and mysql database, and created user for the database, then replace the credentials in my codes so that my website can access the database properly. However I got this error; connection failed:Access denied for user 'root_admin'@'%' to database 'mydb' , even though I already checked that all the credentials are correct. Any help would be greatly appreciated, and would reply if you need any further information. I am also planning to remotely access to the mysql database via python code on my local machine using the mysql.connector python library to read and write records.
Change timezone of the database
in Customer Service
Posted
Hello, I have this prepared statement on my code:
$insert = "INSERT INTO user (user_id, name, date_in, time_in) VALUES (?, ?, CURRENT_DATE, CURRENT_TIME)";
I tested on xampp (localhost) and the value that is inserted on time_in column every time i run this prepared statement is the same as my local time, however I notice when I tried it here on heliohost and check my database, the inserted values for time_in column is different from my time. My question is how can I change the timezone of the database so that the time that would be inserted on time_in column is similar to my local time?