Peter

Sorry for the delay: # who am i -> root pts/3 2017-11-28 15:25 (xxx.xxx.xxx.xxx) and echo $HOME -> /root

Also I can do sudo su and I'm login(?) as another root or what because the terminal history has another commands which are executed

# whoami -> root and # sudo whoami -> root

It's empty -rw-r--r--. 1 root root 0 13 sep 11,20 .odbc.ini

I've updated my question again. The ODBC is working with SUDO but not working without sudo. So, I don't believe there is an issue in ODBC configs. More like permissions issue.

Is it possible because mysql is running on user mysql which may not have permissions to use odbc and that's why with sudo is working? If yes, how can I give permissions?

I've updated my question with odbc.ini. ~/.odbc.ini is empty

All files are with user and user groups root

I've added the content. It's the default one. I didn't changed there anything.

Thanks for the answer. I have updated my question. Can you take a look?