title: Checking whether user entered username and password exists in MYSQL database
body: <p>Im new to python and I am creating a program that checks whether desired user entered username and password exists in database. Here is the code:    </p>
  
  <pre><code> import mysql.connector
   class data:
   def __init__(self):
  
      self.usernam = input("Enter user name: ")
      self.password= input("Enter Password: ")
  
   a=data()
   conn = mysql.connector.connect(host='localhost',user='root',passwd='root',database='user')
  
  
   loadname= ("select username from user where username='%s'")
   mycursor=conn.cursor()
   mycursor.execute(a.usernam, loadname)
   usercheck=mycursor.fetchone()
   loadpass= ("select pass from user where pass ='%s'")
   mycursor2=conncursor()
   mycursor2.execute(a.password,loadpass)
   passcheck=mycursor2.fetchone()
  
  
   if a.username == usercheck and a.password == passcheck:
       print ("pass")
  
   else:
       print ("sorry")
   conn.commit()
   conn.close()
  </code></pre>
  
  <p>Im getting the following errors:</p>
  
  <pre><code>   Traceback (most recent call last):
       File "C:\Users\HP\Desktop\2nd.py", line 16, in &lt;module&gt;
       mycursor.execute(a.usernam, loadname)
       File "C:\Python34\lib\site-packages\mysql\connector\cursor.py", line                                 507, in execute
       self._handle_result(self._connection.cmd_query(stmt))
       File "C:\Python34\lib\site-packages\mysql\connector\connection.py", line 722, in cmd_query
       result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
       File "C:\Python34\lib\site-packages\mysql\connector\connection.py", line 640, in _handle_result
        raise errors.get_exception(packet)
       mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asaa' at line 1
  </code></pre>