Im trying to access the database from a Python script on my PC, but i keep getting an error “Access denied for user ‘foiwette_admin’@‘p548B9092.dip0.t-ipconnect.de’ (using password: YES)”.
I created a MySql user and gave that user all priviliges. Then i used the user credentials for my connection. The same error happens when I try to use my cpanel login credentials.
What I’m using to create the connection is:
user = ‘foiwette_admin’
password = ‘mypassword’ (this would be the mysql user password)
host = ‘foi-wetter.info’
port = 3306
database = ‘foiwette_wetter’
so the full connection creation would look like this
conn = mysql.connector.connect(user=‘foiwette_admin’, password=‘mypassword’, host=‘foi-wetter.info’, port=3306, database=‘foiwette_wetter’)
the website url is: foi-wetter.info