Raspberry pi3 Mysql Python ERROR

Question

Hi I'm trying to connect from python to MySQL but I can't apparently due to below error. I tried it with this...

import MySQLdb
cnx = MySQLdb.connect(user     ='phpmyadmin',
                      passwd   ='raspberry', 
                      host     ='192.168.0.58',
                      database ='freddy')

print 'connected'
cnx.close()

and then i changed "Mysqldb" to "Mysql.connector" but doesnt work. This is the error showing :

Traceback (most recent call last): File "test.py", line 2, in cnx = MySQLdb.connect(user='phpmyadmin',passwd='raspberry',host='192.168.0.58',database='freddy') File "/usr/lib/python2.7/dist-packages/MySQLdb/init.py", line 81, in Connect return Connection(*args, **kwargs) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 204, in init super(Connection, self).init(*args, **kwargs2) TypeError: 'database' is an invalid keyword argument for this function ....

what should i do? i know my password its fine, but must be somethig else...

Finish the tour and check in a bit how I reformatted your question to fit the requirements of SO. — ZF007
– ZF007, Commented Jan 29, 2018 at 22:32
If one of the provided answers worked for you please select it as best answer and upvote it. — ZF007
– ZF007, Commented Jan 29, 2018 at 22:45

ZF007 · Accepted Answer · 2018-01-29 22:41:16Z

0

The word database should be db and then you should be fine and connect.

Change your loginpart into below code:

cnx = MySQLdb.connect(user   ='phpmyadmin',
                      passwd ='raspberry', 
                      host   ='192.168.0.58',
                      db     ='freddy')

This gives you oversight of used keys and values. Enjoy ;-)

answered Jan 29, 2018 at 22:41

ZF007

3,7419 gold badges33 silver badges52 bronze badges

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

24 Comments

Freddy Alex Saavedra Over a year ago

i did it, now is showing this error : Traceback (most recent call last): File "test.py", line 2, in <module> cnx = MySQLdb.connect(user='phpmyadmin',passwd='raspberry',host='192.168.0.58',db='freddy') File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect return Connection(*args, **kwargs) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 204, in init super(Connection, self).__init__(*args, **kwargs2) _mysql_exceptions.OperationalError: (2003, 'Can\'t connect to MySQL server on \'192.168.0.58\' (111 "Connection refused")')

ZF007 Over a year ago

That's another question.. did you check if this is posted as a question on SO? The traceback in your comment should be posted as new question if nothing can be found. Or you could have posted it like: Traceback: OperationalError: (2003, 'Can\'t connect to MySQL server on \'192.168.0.58\' (111 "Connection refused")') .

ZF007 Over a year ago

Check if your user/pass credentials are captial sensitive server-side and if the db is named correct as you provided in your posted code. Also, turn on debugging, eventlog or errorlog server-side to see what's going on. This is error is server-side and not Py!

Freddy Alex Saavedra Over a year ago

my user name and pass are fine, beacuse i cann acces by the browser , and also if i do mysql -u phpmyadmin -prasberry i can acces to maria db, but the error keep showing.

ZF007 Over a year ago

euhm... db = 'freddy' vs. db = 'maria'... makes sense ;-)

|

Collectives™ on Stack Overflow

Raspberry pi3 Mysql Python ERROR

1 Answer 1

24 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

24 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related