Python connecting to remote SQL server

Question

I am having issues connecting to a remote SQL server.

dbconfig = {
  'user': 'dbuser',
  'password': 'password',
  'host': '123.45.6.789',
  'database': 'dbname',

}

def import_prices():
    cnx = mysql.connector.connect(**dbconfig)
    cur = cnx.cursor()

The error I am getting is:

mysql.connector.errors.ProgrammingError: 1045 (28000): 
Access denied for user dbuser'@'12-34-45-555-dynamic.agg1.roc.bbh-prp.eircom.net' 
(using password: YES)

I don't know why it is adding my hostname (from internet connection) to the user. The database was set up in cPanel and when I connect from it from within the server I just use localhost.

Colin Schoen · Accepted Answer · 2015-11-13 00:38:55Z

1

Likely this is not a Python or remote issue, but rather that you need to configure the mySQL server to accept connections for dbuser from either all hosts your specific host (IP).

answered Nov 13, 2015 at 0:38

Colin Schoen

2,5881 gold badge20 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MSven · Accepted Answer · 2015-11-13 02:30:06Z

0

To expand on Colin, you probably need to do something like below:

CREATE USER 'dbuser'@'123.45.6.789' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON dbname.* TO 'dbuser'@'123.45.6.789';

answered Nov 13, 2015 at 2:30

MSven

364 bronze badges

Collectives™ on Stack Overflow

Python connecting to remote SQL server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related