title: Configuring MySql inWildFly
body: <p>I followed the steps trying to configure MySQL in WildFly. I have two questions for your help with:</p>
  
  <p>1) I downloaded the mysql-connector-java-5.1.33-bin.jar and placed it under modules/system/layers/base/com/mysql/main/. Do I need to download the actual MySql? Or the connector jar is sufficient?</p>
  
  <p>2) In creating a new data source in WildFly console, I was not able to create a new data source. Part of the information I need to fill in is a pair of user name and password to access the database. Where should I create this user name and password first? I am guessing this is where I got the problem from. </p>
  
  <p>I got this error message when testing the connection in wildfly console:</p>
  
  <pre><code>Unexpected HTTP response: 500
  
  Request
  {
      "address" =&gt; [
          ("subsystem" =&gt; "datasources"),
          ("data-source" =&gt; "mysqlDSPool")
      ],
      "operation" =&gt; "test-connection-in-pool"
  }
  
  Response
  
  Internal Server Error
  {
      "outcome" =&gt; "failed",
      "failure-description" =&gt; "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid",
      "rolled-back" =&gt; true
  }
  </code></pre>