Connect python to MySQL

Import  Mysqldb  #  Case Sensitive !!  
#  Establish a connection with the database system  
  Conn  =  Mysqldb. Connect (host  ='  Localhost', user  =  'Root', passwd  =  'Smile ', DB  = 'Test ')
  #  Get operation cursor  
  Cursor  =  Conn. cursor ()
  #  Run SQL to create a database.  
  Cursor.exe cute ("""  Create Database Python """  )
Cursor.exe cute ('create table test ')
  #  Insert parameter value  
 Values  =  []
  For  I  In  Range (  20  ):
Values. append (I, 'Hello mysqldb, I am recoder'  +  STR (I )))
  #  Insert multiple records  
  Cursor.exe cute.pdf ('''  Insert into test values (% s, % s )''' , Values );
  #  Submit changes  
  Conn. Commit ()

Count  =  Cursor.exe cute ('select  *     From  Test ')
Results  =  Cursor. fectch.pdf (  5  )
  # Reset the cursor position. The value 0 indicates the offset. mode = absolute | relative is used. The default value is relative,  
  Cursor. Scroll (0, Mode  =  'Abort ')
Results  =  Cursor. fetchall ()
  #  Close connection and release resources  
  Cursor. Close ();