Testing the DataSource with MySQL
I have done the datasource testing with SQL Server 7.0 (Desktop Edition) ,testing was completed sucessfully.
But to MySQL, i think there should have been one driver for Configuration(Administrative Tools---->ODBC---->Add--->Finish)
i have given DataSource name as MySQL ,Server name as localhost, LoginID ---- root and password ---1234.
System gave error message as Connection failed : SQL State : 28000 and the SQL Error :18456,login failed for User :root.
How to begin and complete the entire workflow for testing the datasource with MySQL .