import clr clr.AddReferenceByPartialName ('System.Data') clr.AddReferenceToFile ('MySql.Data.dll') from System.Data import * from MySql.Data.MySqlClient import * connstr = 'server=%s;User Id=%s;Password=%s;Database=%s' % ('192.168.250.217','wordpress', 'wordpress', 'wordpressme') def show_charset(conn): cmd = conn.CreateCommand () cmd.CommandText = 'show variables like \'char%\'' r = cmd.ExecuteReader ()while r.Read (): print '%s:%s' % (r[0], r[1]) r.Close () conn = None try: conn = MySqlConnection (connstr) conn.Open () show_charset(conn) finally: if not conn is None: conn.Close ()
