[Python] I want to connect from python to mariadb database but an error [closed]

I want to connect from python to mariadb database but an error like this occurs, what do you think is the reason?

This is my coding

import pymysql
import pymysql.cursors


#membuat koneksi ke database mysql
connection = pymysql.connect(
host='localhost',
user='root',
password='',
charset='utf8',
cursorclass=pymysql.cursors.DictCursor
)

#membuat cursor
cursor = connection.cursor()

#membuat database baru
cursor.execute("CREATE DATABASE IF NOT EXIST test_db")
cursor.execute("USE test_db")


Traceback (most recent call last):
File "d:\Nabil Ghibran\Alpro lanjut\Pertemuan 13\latihan_mysql.py", line 18, in <module>
cursor.execute("CREATE DATABASE IF NOT EXIST test_db")
~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\advan\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 153, in execute
result = self._query(query)
File "C:\Users\advan\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 322, in _query
conn.query(q)
~~~~~~~~~~^^^
File "C:\Users\advan\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 563, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\advan\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 825, in _read_query_result
result.read()
~~~~~~~~~~~^^
File "C:\Users\advan\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 1199, in read
first_packet = self.connection._read_packet()
File "C:\Users\advan\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 775, in _read_packet
packet.raise_for_error()
~~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\advan\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File "C:\Users\advan\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'EXIST test_db' at line 1")


please help me, I just started mysql lessons, I have followed all the coding and instructions from my lecturer

Continue reading...