Mysql Connection error


on a customer’s pc I get the following error when accessing a webapp…

Connection error:Access denied for user ‘ODBC’@‘localhost’ (using password: NO)

the host, user and password are ok, tried on my developing machine and works…any idea??

tried with mysql community 5.6 and 5.7


Well, you say the password is ok, but according to the error you’re not using a password?

I know, and also the problem is that I didn’t creare an user named ODBC !!!

I think is a common problem when used in win (just googling it) but cannot solve…

I am guessing that their machine is not at localhost, they are a user at an address elsewhere. Set the user ODBC to be to be able to access the database from elsewhere, i.e. % (any host). When you connect to the database it knows where you are connecting from as the i.p address is also sent, thats my simplified understanding.

the strange thing is that with mysql workbench and root user I can connect and manage everything

I also created an odbc user with no password and % in the host access but same issue…

the same xojo webapp running on my machine with root user in the connection string works!

the error is raised just before tha page is showed…and at every connection to the db (query,…)