What is the correct syntax for pymysql commands?

Question

I can't execute the query.

pymysql is already installed using pip install pymymql.

Code

import pymysql

db = pymysql.connect(host='localhost', user='root', passwd='')
cursor = db.cursor()
query = ("SHOW DATABASES")
cursor.execute(query)

for r in cursor:
    print (r)

Error

Traceback (most recent call last):
  File "C:\Users\Ironman\Desktop\testdbase.py", line 2, in <module>
    db = pymysql.connect(host='localhost',user='root',passwd='')
  File "C:\Users\Ironman\AppData\Local\Programs\Python\Python37-32\pymysql\__init__.py", line 94, in Connect
    return Connection(*args, **kwargs)
  File "C:\Users\Ironman\AppData\Local\Programs\Python\Python37-32\pymysql\connections.py", line 325, in __init__
    self.connect()
  File "C:\Users\Ironman\AppData\Local\Programs\Python\Python37-32\pymysql\connections.py", line 585, in connect
    self._request_authentication()
  File "C:\Users\Ironman\AppData\Local\Programs\Python\Python37-32\pymysql\connections.py", line 847, in _request_authentication
    auth_packet = self._read_packet()
  File "C:\Users\Ironman\AppData\Local\Programs\Python\Python37-32\pymysql\connections.py", line 670, in _read_packet
    packet.check_error()
  File "C:\Users\Ironman\AppData\Local\Programs\Python\Python37-32\pymysql\protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "C:\Users\Ironman\AppData\Local\Programs\Python\Python37-32\pymysql\err.py", line 104, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")

Answer 1

I just missed the port. It's 9321 in my XAMPP instance.