resparkman1

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?

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?

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 ?

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.