title: Successfully access MySQL database from python using optuna
body: <p>Since the <code>optuna</code> documentation does not address which modules are required from MySQL, I installed everything of MySQL on my Windows 10 machine. I looked for MySQL on my PC (in which folder the installation takes place is not revealed during installation) and updated the Path variables to</p>
  <p>C:\Program Files\MySQL\MySQL Server 8.0\bin</p>
  <p>I have successfully created the <code>mysqltestexample</code> database.</p>
  <p><a href="https://i.stack.imgur.com/QfacP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QfacP.png" alt="enter image description here" /></a></p>
  <p>Using python SQL connectors, I can reproduce the output using:</p>
  <pre><code>import mysql.connector
  
  mydb = mysql.connector.connect(
    host=&quot;localhost&quot;,
    user=&quot;root&quot;,
    password=&quot;Start123&quot;
  )
  
  print(mydb)
  
  
  mycursor = mydb.cursor()
  
  mycursor.execute(&quot;SHOW DATABASES&quot;)
  
  for x in mycursor:
    print(x) 
  
  mydb = mysql.connector.connect(
    host=&quot;localhost&quot;,
    user=&quot;root&quot;,
    password=&quot;Start123&quot;,
    database=&quot;mysqltesteexample&quot;
  ) 
  </code></pre>
  <p>Connection to the <code>mysqltesteexample</code> does not raise an error - so everything seems to be fine. However, <code>optuna</code> is not able to connect to my database</p>
  <p>My python script looks like this. It is the code from the <code>optuna</code> documentation, I just altered the name of the test database.</p>
  <pre><code>study0 = optuna.create_study(storage=&quot;mysql://root@localhost/mysqltesteexample&quot;,study_name=&quot;distributed-example&quot;)
  study0 = optuna.create_study(storage=&quot;mysql+pymysql://root:Start123@localhost:3306/mysqltesteexample&quot;,study_name=&quot;distributed-example&quot;)
  </code></pre>
  <p>All attempts to modify the URL string according to <a href="https://docs.sqlalchemy.org/en/14/core/engines.html" rel="nofollow noreferrer">https://docs.sqlalchemy.org/en/14/core/engines.html</a> failed with the following error: <code>ImportError: Failed to import DB access module for the specified storage URL. Please install appropriate one.</code>
  Can you please help me to get it done? Thank you in advance, please don't be too harsh.</p>