What information is needed to connect to a MySQL database?

In order to connect to a MySQL database server, you need to get the following information from your DBA:

• Host Name: This is the host name on the network, or the IP address that runs the MySQL database server.
• Port Number: This is the port number where the MySQL database server is listening client connection requests. The default port number for MySQL server is 3306.
• User Name: This is the user name that created by the DBA on the MySQL database server.
• Password: This is the password that protects the user name on the MySQL database server.
• Database Name: The database instance name that is allowed for your user name to access. This is not needed, if your user name is given with the privilege to query for database names.

For example, you might be given the following information to access a database on the local MySQL server.

Host Name: 127.0.0.1
Port Number: 3306
User Name: guest
Password: retneciyf
Database Name: test

⇒ "mysql.connector" Module by mysql.com

⇐ Python Modules for MySQL Database

⇑ Python Modules for MySQL Database

⇑⇑ Python Tutorials