Access denied for user 'ODBC'@'localhost'

Question

I've looked everywhere an cannot seem to find a fix for this issue, despite tons of articles on it. Anyway, I'm attempting the following command

mysqldump -hlocalhost -uroot -p mydb mytable > myexportedtable.sql

This will occasionally result in the following error

mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' <using password:NO> when trying to connect

This is baffling for two reasons. One - I am specifying a root user in my command however it assumes I'm ODBC. Two - I only get this error occasionally. (more often than not). I am able to authenticate to the mysql interactive shell when specifying root but keep getting this error with mySQL dump. Any insight is greatly appreciated as I've been trouble shooting this for days now.

Are you omitting the space between `-u` and `root` or is just a typo in your question? — didierc, Jul 20 '14 at 20:44
Also, note that the default host is localhost, so you don't actually need to specify it. — didierc, Jul 20 '14 at 20:46
Test ODBC connection from ODBC Manager in Control Panel. Probably it has bad configuration there. Try using DSN. — i486, Dec 25 '14 at 14:40

score 8 · Accepted Answer · answered Aug 15 '16 at 17:14

8

Type in the command manually. Sometimes copying and pasting the command changes the hyphen character (-). It is ignoring the username because it literally doesn't recognize a -u.

answered Aug 15 '16 at 17:14

S Quint

96
1
2

score 1 · Answer 2 · edited Jan 21 '23 at 00:13

This seems to happen when you connect with the wrong user to the database, wrong password usage or when you connect from the wrong host or over the socket/port when you are not allowed to.

I suggest checking the access privileges of the user like:

mysql> SELECT user, host FROM mysql.user WHERE user = 'jake';
mysql> SHOW GRANTS FOR 'jake'@'localhost';

Perhaps also take a look at mysqlimport: Error: 1045, Access denied , which helped me a lot.

Access denied for user 'ODBC'@'localhost'

2 Answers2