I'm trying to connect to a remote MySQL database using MySQLdb.connect (db = 'mydb', user = 'myuser', host = 'http://server.myhost.com', passwd = 'mypwd')
I get an OperationalError 1045 saying access is denied for user "myuser@dialup-4.225.213.236.Dial1.Denver1.Level3.net"
why is the @dialup etc being appended to the user, and how can I prevent it?'
tia,
paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm trying to connect to a remote MySQL database using MySQLdb.connect (db = 'mydb', user = 'myuser', host = 'http://server.myhost.com', passwd = 'mypwd')
I get an OperationalError 1045 saying access is denied for user "myuser@dialup-4.225.213.236.Dial1.Denver1.Level3.net"
why is the @dialup etc being appended to the user, and how can I prevent it?'
tia,
paul
> Are you seriously puting http:// in the host?
i tried it with and without in case that was the problem, which it apparently isn't..
so it sounds like the server is accepting the connection - which would explain some other things...
thanks for clarifying
pj
versions: MySQLdb rev 1.37, Python 2.4, MySQL 4.1.11
i've tried this on another db which I can connect to using a hosted phpMyAdmin interface, and get the same behaviour...
thanks again,
pj
Are you seriously puting http:// in the host?
Your remote server is putting that name in there; it's not anything MySQLdb is doing.