Default password for MySQL connection in Python

Question

I installed MySQL with pip install mysql-connector-python.

But for connecting in Python I don't know what password to use.

mysqldb=mysql.connector.connect(host="localhost",user="",password="",database="")

The password is not defined by the database adapter, it is defined by the MySQL server. — Klaus D.
– Klaus D., Commented Feb 23, 2022 at 16:24
How install mysql for python? i use this command but get error pip install MySQL-python, — Mohsen Eslami mehr
– Mohsen Eslami mehr, Commented Feb 23, 2022 at 16:51

pepeD · Accepted Answer · 2022-02-23 16:26:22Z

0

Don't use password, just use host. https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html

(Btw. this is just connecting package, you need MySql server too - https://pypi.org/project/MySQL-python/)

answered Feb 23, 2022 at 16:26

pepeD

1743 silver badges17 bronze badges

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

3 Comments

Matthias Over a year ago

Could you explain what you mean with "just use host"? On the page you linked to I can find the following: "Authentication with MySQL typically uses a username and password."

pepeD Over a year ago

@Matthias Look at Table 7.1 - Default values

Matthias Over a year ago

I don't get it. user and password have no default values, so they are clearly missing if I don't provide them. One could omit host if it's running on localhost (aka 127.0.0.1), but one has to provide user and password.

Collectives™ on Stack Overflow

Default password for MySQL connection in Python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related