Raspberry Pi Forums

Posted: **Mon Oct 17, 2016 7:12 pm**

I can connect successfully to my DB using my root account through MySQLdb.

db = MySQLdb.connect("192.168.1.664", "root", "MyRootPassword", "piclock")

I made a new user account (webguy) w/ only SELECT, INSERT, and UPDATE priveledges, but the connection fails with the following message..

_mysql_exceptions.OperationalError: (1045, "Access denied for user 'webguy'@'192.168.1.204' (using password: YES)")

The same account (webuy) works fine with my php connection, but not with the python connection

Posted: **Mon Oct 17, 2016 8:51 pm**

Grab the perl script from the comments at: http://dev.mysql.com/doc/refman/5.7/en/show-grants.html and run that. It will show exactly what privileges you've granted.

MySQLdb python connection using non-root account?