How to Install confluence wiki on linux server(64 bit) + mysql database configuration error

I have referred following URL to install the confluence wiki on linux(64 bit).

=====
http://confluence.atlassian.com/display/DOC/Installing+Confluence+Standalone+on+UNIX+or+Linux
=====

Regarding the DB setting you can refer the following URL :


====
http://confluence.atlassian.com/display/DOC/Database+Setup+For+MySQL

NB: You need to create one db user and db password. Just give grant privileges to the "confluence" db or customized DB that you had manually created.

====
http://confluence.atlassian.com/display/DOC/Configuring+a+MySQL+Datasource+in+Apache+Tomcat
====

Here are the error messages that I had received during configuring the DB at the browser.

====
* Configuring the database failed. Couldn't create the database schema.
* com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3 times.
Giving up
====

Sol : 1. The error is basically happened for mismatching of DB engine.
2. checked the DB engine at the backend like mysql# show variable like "%engine%";
3. Now you'll see the URL to connect the DB via jdbc driver like :
jdbc:mysql://localhost/confluenceuser?autoReconnect=true&sessionVariables=storage_engine%3DInnoDB

4. For my case DB engine was MyIsAm at mysql.
5. I setup the following URL :
jdbc:mysql://localhost/confluenceuser?autoReconnect=true&sessionVariables=storage_engine%3DMyIsAm
6. Then I proceeded further and I had successfully installed the software.
By : webhostingtalk.com