At a guess I'd say you are not using the correct password in your ODBC connection for MySQL user 'root'.
In general for security reasons it is not a good idea to use user 'root' for anything apart from admin. Better to create a new user in MySQL for your application and set up an ODBC connection to that new user.
This is a Microsoft SQL Server forum. It would be better to direct your question to a MySQL forum.