resparkman1 Posted March 23 Share Posted March 23 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? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.