运行SQL时，无法进入

Question

我想使用Python将检索到的数据存储在我所选择的笔记本电脑的数据库中？

是否有任何设置和连接？

我做了：

pip install mysql.connector

以下：Python MySQL - CodersLegacy^

我试过之后：

import mysql.connector
 
check = mysql.connector.connect(
    host= 'localhost',
    user = 'root',
    password = '12345678')
 
print(check)

它给了我错误：

---------------------------------------------------------------------------
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\

Answer 1

问题可能是因为连接器没有指定要连接到的数据库的名称。否则代码也能正常工作，但您可能需要尝试一下。例如：

mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="12345678", 
  database="name_of_your_database"
)
print(mydb)