I want to store retrieved data in a database of my choice in my laptop using Python?
Is there any setting and connection?
I had done:
pip install mysql.connector
following:
Python MySQL - CodersLegacy[
^]
After I had tried:
import mysql.connector
check = mysql.connector.connect(
host= 'localhost',
user = 'root',
password = '12345678')
print(check)
It give me error:
---------------------------------------------------------------------------
InterfaceError Traceback (most recent call last)
<ipython-input-4-e72118a94c51> in <module>()
3 check = mysql.connector.connect(
4 host= 'localhost',
----> 5 user = 'root')
6
7
C:\Users\id\AppData\Local\Continuum\anaconda2\lib\site-packages\mysql\connector\__init__.pyc in connect(*args, **kwargs)
177 return CMySQLConnection(*args, **kwargs)
178 else:
--> 179 return MySQLConnection(*args, **kwargs)
180 Connect = connect # pylint: disable=C0103
181
C:\Users\id\AppData\Local\Continuum\anaconda2\lib\site-packages\mysql\connector\connection.pyc in __init__(self, *args, **kwargs)
93
94 if len(kwargs) > 0:
---> 95 self.connect(**kwargs)
96
97 def _do_handshake(self):
C:\Users\id\AppData\Local\Continuum\anaconda2\lib\site-packages\mysql\connector\abstracts.pyc in connect(self, **kwargs)
714
715 self.disconnect()
--> 716 self._open_connection()
717 self._post_connection()
718
C:\Users\id\AppData\Local\Continuum\
What I have tried:
import mysql.connector
check = mysql.connector.connect(
host= 'localhost',
user = 'root',
password = '12345678')
print(check)