jboss-cli setting a datasource

wildfly8.1- standalone

Testing with 5.1.38 ( mysql-connector-java-5.1.38-bin.jar  5.1.38 ) 

~log in to admin~
$./bin/jboss-cli.sh --connect 

~before you start, take a snapshot of the configuration :~
~snapshot is saved in -> /wildfly/standalone/configuration/standalone_xml_history/snapshot~

[domain@localhost:9999 /] :take-snapshot()

~mysql-connector-java-5.1.38 ~
[domain@localhost:9999 /] ) 
deploy ~/<location-directory>/mysql-connector-java-5.1.38-bin.jar

~remove your old connection, ex NaturDS ~
[domain@localhost:9999 /]  data-source --name=NaturDS disable
[domain@localhost:9999 /]  /:reload
[domain@localhost:9999 /]  data-source --name=NaturDS remove

~Add the new connection, ex NaturDS ~
[domain@localhost:9999 /]  data-source  add --name=NaturDS --jndi-name=java:/NaturDS  --driver-name=mysql-connector-java-5.1.38-bin.jar_com.mysql.jdbc.Driver_5_1  --connection-url=jdbc:mysql://localhost:3306/taxonpages_v2  \
    --user-name=root --password=boho \
    --check-valid-connection-sql="SELECT 1" \
    --background-validation=true \
    --background-validation-millis=60000 \
    --flush-strategy=IdleConnections \
    --min-pool-size=10 --max-pool-size=50  --pool-prefill=false
    
The out put is in standalone.xml ( cat standalone.xml)
<datasource jndi-name="java:/NaturDS" pool-name="NaturDS" enabled="true">
                    <connection-url>jdbc:mysql://localhost:3306/taxonpages_v2</connection-url>
                    <driver>mysql-connector-java-5.1.38-bin.jar_com.mysql.jdbc.Driver_5_1</driver>
                    <pool>
                        <min-pool-size>10</min-pool-size>
                        <max-pool-size>50</max-pool-size>
                        <prefill>false</prefill>
                        <flush-strategy>IdleConnections</flush-strategy>
                    </pool>
                    <security>
                        <user-name>root</user-name>
                        <password>boho</password>
                    </security>
                    <validation>
                        <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
                        <background-validation>true</background-validation>
                        <background-validation-millis>60000</background-validation-millis>
                    </validation>
 </datasource>


check Information:
5) /subsystem=datasources/data-source=NaturDS:read-resource(include-runtime=true,recursive=true)

ping your data-source
6) /subsystem=datasources/data-source=NaturDS:test-connection-in-pool

7) data-source flush-all-connection-in-pool --name=NaturDS