Connect to mySQL with python 3

Question

I have a problem with mySQL

I installed it on my raspberry pi - python 3 virtual environment with the following command:

sudo pip install mysql-connector

I have the following script:

import mysql.connector

mydb = mysql.connector.connect(
    host="127.0.0.1",
    port="11300",
    user="pi",
    passwd="1234"
 )

print(mydb)

But nothing happens, no error, no connection, ... I found the port number with the command 'netstat' under TCP connection

That means its working so go ahead and do something do some query etc.. — which_part
– which_part, Commented Aug 17, 2018 at 7:00
I was expecting something like <mysql.connector.connection.MySQLConnection object ar 0x16645F0> but ok, I did another test with mycursor = mydb.cursor() and mycursor.execute("CREATE DATABASE myDatabase") and after this, search for the database: mycursor.execute("SHOW DATABASE") but still nothing happens... — Werbrouck Bram
– Werbrouck Bram, Commented Aug 17, 2018 at 8:27
I read those comments, and tried some things out, but still nothing happens... — Werbrouck Bram
– Werbrouck Bram, Commented Aug 17, 2018 at 9:12

Lasha Kitia · Accepted Answer · 2018-08-17 14:22:59Z

1

after execute you need to open cursor, to get result you can open cursors like:

mycursor.fetchall() returns iterable object.

for row in mycursor.fetchall():
    print(row)

mycursor.fetchone() fetches first row from result

print(mycursor.fetchone())

P.S. are you sure that you've installed that package properly?

e.g.: for ubuntu you can install this package for python3 by typing:

apt install python3-mysql.connector

edited Aug 17, 2018 at 14:22

answered Aug 17, 2018 at 13:33

Lasha Kitia

1417 bronze badges

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

15 Comments

Werbrouck Bram Over a year ago

The installation was successful, When I type mysql --help in the prompt, and look at port I have a value 0 is this normal? and now with netstat I don't see the TCP/IP anymore ??

Lasha Kitia Over a year ago

port value 0 is normal. you've executed mycursor.execute("SHOW DATABASE") can you please try: mycursor.execute("SHOW DATABASES") and get rows by opening cursor

Werbrouck Bram Over a year ago

this is what I have

import mysql.connector  try:      mydb = mysql.connector.connect(user='pi',password='1234',host='127.0.0.1',port='11300',database='test')     mycursor = mydb.cursor()     mycursor.execute("SHOW DATABASES")     mycursor.fetchall()  except:     print("error")

But still I got nothing, It's like the prompt is waiting for something, but I can do anything..

Lasha Kitia Over a year ago

after executing try running this: for row in mycursor.fetchall(): print(row)

Lasha Kitia Over a year ago

@WerbrouckBram I've edited main answer, check examples there

|

Collectives™ on Stack Overflow

Connect to mySQL with python 3

1 Answer 1

15 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

15 Comments

Linked

Related