title: Connect to Synology database with python
body: <p>I don't have experience in databases, and I want to connect to a MariaDB10 database in a Synology NAS using python. I'm completely lost.</p>
  
  <p>So far I tried the following code:</p>
  
  <pre><code>import mysql.connector as msq
  connection=msq.connect(host="192.168.0.36",
                         port="3307",
                         unix_socket="run/mysqld/mysqld10.sock",
                         user="user", 
                         password='pwd', 
  </code></pre>
  
  <p>I get an output like this:</p>
  
  <pre><code>DatabaseError: Host '192.168.0.18' is not allowed to connect to this MariaDB server
  </code></pre>
  
  <p>I also don't understand why the ip changes. Probably there are many things wrong on that code. Can someone please help me? did you do it before?</p>