I want to read mysql table data to an excel file. So I decide to install MyODBC in my Ubuntu 11.04 with these command lines:
sudo apt-get install iodbc sudo apt-get install libmyodbc
I start the iODBC Driver Manager GTK+ frontend and config ODBC drivers look like in the picture:
Then I add a new USER DNS :
Try to login for DNS with User = root and Empty password give me this error :
I windows I can use ODBC without any problem.
What was I wrong and missing here? Please help!
Thanks in advance.