Python connects to MySQL database

First, configure the Yum source after installing MySQL, MySQLdb, Mysql-devel.

Yum Install mysql-server Mysql-python mysql-devel

After installation, execute the following command in the Python environment, and no output proves the installation was successful.

Import MySQLdb

Second, write a simulation user login program to further enhance learning.

Code ideas:

Receives the user name and password from the input device and then goes to the library to query, if it can match to the return true to allow login, if unable to match the return false deny login.

#/usr/bin/env pythonImportMySQLdb

#mysql配置文件dbconfig= {    'User':'Root',    'Host':'localhost',    'passwd':"',    'DB':'Zhonggu',    'CharSet':'UTF8',}conn= MySQLdb.connect (* *dbconfig) #连接mysqlcursor=conn.cursor ()defUser_login (Name,password): SQL="SELECT * from user where name=%s and password=%s"#查询的SQL语句    ifcursor.execute (SQL, (name, password)):returnTrueElse:        returnFalsename= Raw_input ("Input your name:") Password= Raw_input ("Input your password:")Printuser_login (name, password) cursor.close () conn.close ()

Python connects to MySQL database