Access denied to user ODBC, but trying to login as root
The only thing I can suggest is to explicitly choose a host by doing one of the following:

mysqldump -hlocalhost -uroot -ppassword ideal_inv &gt; ideal_inv.sql

mysqldump -h127.0.0.1 -uroot -ppassword ideal_inv &gt; ideal_inv.sql