Book Image

Python GUI Programming Cookbook

By : Burkhard Meier
Book Image

Python GUI Programming Cookbook

By: Burkhard Meier

Overview of this book

Table of Contents (18 chapters)
Python GUI Programming Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Configuring the MySQL connection


In the previous recipe, we used the shortest way to connect to a MySQL server by hard-coding the credentials required for authentication into the connection method. While this is a fast approach for early development, we definitely do not want to expose our MySQL server credentials to anybody unless we grant permission to databases, tables, views, and related database commands to specific users.

A much safer way to get authenticated by a MySQL server is by storing the credentials in a configuration file, which is what we will do in this recipe.

We will use our configuration file to connect to the MySQL server and then create our own database on the MySQL server.

Note

We will use this database in all of the following recipes.

Getting ready

Access to a running MySQL server with administrator privileges is required to run the code shown in this recipe.

Note

The previous recipe shows how to install the free Community Edition of MySQL Server. The administrator privileges...