cnx = connector.connect(host='I_really_don_t_know_what_to_use_here', password='your_password', user="your_user", database="the_database")

class ActionBookRoom(Action):
    def name(self):
        return 'action_room'

    def run(self, dispatcher, tracker, domain):
        print("inside run")
        name_room = tracker.get_slot('name_room')
        day = tracker.get_slot('day')
        hour_start = tracker.get_slot('hour_start')
        duration = tracker.get_slot('duration')

        booking_answer = make_a_booking(name_room, day, hour_start, duration)
        print("passed booking")
        if booking_answer:
            booking_answer = 'The reservation has been made'
        else:
            booking_answer = 'The room is taken at this hour'

        response = """You want to book the {} room on {} at {} for {}. Is it correct ?""".format(name_room, day, hour_start, duration)

        name_room = str(name_room)
        day = str(day)
        hour_start = str(hour_start)
        duration = str(duration)
        print("before connexion")
        #SQL queries#
        cnx = connector.connect(host='I_don_t_know_what_to_use_here', password='my_mysql_cmd_password', user="root", database="the_database")
        print("after connexion")

        dispatch = dispatcher.utter_message(response)
        dispatch = dispatcher.utter_message(str(booking_answer))

        return dispatch

inside run
[2019-02-22 16:52:00,822] ERROR in app: Exception on /webhook [POST]
Traceback (most recent call last):
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnectorconnection_cext.py", line 179, in _open_connection
    self._cmysql.connect(**cnx_kwargs)
_mysql_connector.MySQLInterfaceError: Access denied for user 'root'@'localhost' (using password: YES)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 2292, in wsgi_app
    response = self.full_dispatch_request()
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 1815, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflask_corsextension.py", line 161, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 1718, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflask_compat.py", line 35, in reraise
    raise value
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 1813, in full_dispatch_request
    rv = self.dispatch_request()
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 1799, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflask_corsdecorator.py", line 128, in wrapped_function
    resp = make_response(f(*args, **kwargs))
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesrasa_core_sdkendpoint.py", line 86, in webhook
    response = executor.run(action_call)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesrasa_core_sdkexecutor.py", line 177, in run
    events = action(dispatcher, tracker, domain)
  File "C:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackactions.py", line 42, in run
    booking_answer = make_a_booking(name_room, day, hour_start, duration)
  File "C:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackbooking.py", line 61, in make_a_booking
    cnx = mysql.connector.connect(password='jeb41jeb', user="root", database="alex")
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnector__init__.py", line 172, in connect
    return CMySQLConnection(*args, **kwargs)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnectorconnection_cext.py", line 78, in __init__
    self.connect(**kwargs)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnectorabstracts.py", line 735, in connect
    self._open_connection()
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnectorconnection_cext.py", line 182, in _open_connection
    sqlstate=exc.sqlstate)
mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
2019-02-22 16:52:00 ERROR    flask.app  - Exception on /webhook [POST]
Traceback (most recent call last):
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnectorconnection_cext.py", line 179, in _open_connection
    self._cmysql.connect(**cnx_kwargs)
_mysql_connector.MySQLInterfaceError: Access denied for user 'root'@'localhost' (using password: YES)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 2292, in wsgi_app
    response = self.full_dispatch_request()
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 1815, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflask_corsextension.py", line 161, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 1718, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflask_compat.py", line 35, in reraise
    raise value
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 1813, in full_dispatch_request
    rv = self.dispatch_request()
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflaskapp.py", line 1799, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesflask_corsdecorator.py", line 128, in wrapped_function
    resp = make_response(f(*args, **kwargs))
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesrasa_core_sdkendpoint.py", line 86, in webhook
    response = executor.run(action_call)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesrasa_core_sdkexecutor.py", line 177, in run
    events = action(dispatcher, tracker, domain)
  File "C:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackactions.py", line 42, in run
    booking_answer = make_a_booking(name_room, day, hour_start, duration)
  File "C:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackbooking.py", line 61, in make_a_booking
    cnx = mysql.connector.connect(password='jeb41jeb', user="root", database="alex")
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnector__init__.py", line 172, in connect
    return CMySQLConnection(*args, **kwargs)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnectorconnection_cext.py", line 78, in __init__
    self.connect(**kwargs)
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnectorabstracts.py", line 735, in connect
    self._open_connection()
  File "c:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stackstaenvlibsite-packagesmysqlconnectorconnection_cext.py", line 182, in _open_connection
    sqlstate=exc.sqlstate)
mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

mysql> SELECT User FROM mysql.user;
+------------------+
| User             |
+------------------+
| mike             |
| mysql.infoschema |
| mysql.session    |
| mysql.sys        |
| root             |
+------------------+
5 rows in set (0.00 sec)

(staenv) C:UsersantoiDocumentsProgrammingNathalie18_2_2019starter-pack-rasa-stack>python
Python 3.6.7 (v3.6.7:6ec5cf24b7, Oct 20 2018, 13:35:33) [MSC v.1900 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import mysql.connector
>>> db = mysql.connector.connect(
...     host="localhost",user="root",password="MySQL.2019",database="alex")
>>>
>>> cursor = db.cursor()
>>> cursor.execute("SELECT * FROM reservations")
>>> myresult = cursor.fetchall()
>>> for x in myresult:
...   print(x)
...
(1, 'red', datetime.datetime(2018, 8, 8, 12, 0), None)
(2, 'red', datetime.datetime(2018, 8, 8, 12, 0), None)
>>>