MySQL ODBC Connection Fails?

You should read the MySQL documentation on the access privilege system:
http://dev.mysql.com/doc/refman/5.0/...ge-system.html

And also the reference documentation on the statements used to administer
accounts and grant privileges:
http://dev.mysql.com/doc/refman/5.0/...ement-sql.html

So basically you need to grant privilege to some account on your PC to
connect to one or more databases. For example:

GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'bsanderson' IDENTIFIED
BY 'password';

refer for more details
http://bytes.com/topic/mysql/answers/453605-odbc-not-connection-database

Thanks for the response pratima.

Permissions are absolutely fine. I have had GRANT ALL ON *.* TO user@'%' IDENTIFIED BY 'sec1234'.

* the top 2 links you given seems to be broken, redirecting to Oracle search site.

you could test the connection to the mysql database manually.

e.g mysql -h prodserver.somedomain.com -u user -p pass123

or alternatively via a tool such as heidsql so you can make sure your pc can connect the mysql server. This way you rule out any issues with the connection /  network.

Also, are you able to connect the mysql server from other remote machines? If not you may need to configure the mysql server to be bound to public ips:

comment out bind_address = 127.0.0.1 in /etc/mysql/my.cnf

Aegil, Thanks for the response.

I'm able to connect mysql server from other machines. This is perfect.

It was version problem as I suspect. But no one from here confirm me, so closing the post by accepting my response itself