<p>Python连接示例如下：</p> <table border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-color:#f7f8fa"> <p><span style="font-family:Consolas">#!/usr/bin/python</span></p> <p><span style="font-family:Consolas"># -*- coding: UTF-8 -*-</span></p> <p><span style="font-family:Consolas">import MySQLdb</span></p> <p>&nbsp;</p> <p><span style="font-family:Consolas"># 打开数据库连接</span></p> <p><span style="font-family:Consolas">db = MySQLdb.connect(</span></p> <p><span style="font-family:Consolas">host=&#39;<strong>&lt;</strong><strong>域名&gt;</strong>&#39;,</span></p> <p><span style="font-family:Consolas">port=<strong>&lt;</strong><strong>端口号&gt;</strong>,</span></p> <p><span style="font-family:Consolas">user=&#39;<strong>&lt;</strong><strong>用户名&gt;</strong>&#39;,</span></p> <p><span style="font-family:Consolas">passwd=&#39;<strong>&lt;</strong><strong>密码&gt;</strong>&#39;,</span></p> <p><span style="font-family:Consolas">db=&#39;<strong>&lt;</strong><strong>数据库名&gt;</strong>&#39;)</span></p> <p><span style="font-family:Consolas"># 使用cursor()方法获取操作游标</span></p> <p><span style="font-family:Consolas">cursor = db.cursor()</span></p> <p><span style="font-family:Consolas"># 使用execute方法执行SQL语句</span></p> <p><span style="font-family:Consolas">cursor.execute(&#39;SELECT VERSION()&#39;)</span></p> <p><span style="font-family:Consolas"># 使用 fetchone() 方法获取一条数据</span></p> <p><span style="font-family:Consolas">data = cursor.fetchone()</span></p> <p><span style="font-family:Consolas">print &quot;Database version : %s &quot; % data</span></p> <p><span style="font-family:Consolas"># 关闭数据库连接</span></p> <p><span style="font-family:Consolas">db.close()</span></p> </td> </tr> </tbody> </table>