title: Why this doesn't work: [MySQL][ODBC 5.1 Driver]Access denied for user
body: <p>So I know that there is a very similar question to this all over the web as well as stack overflow:</p>
  
  <p><a href="https://stackoverflow.com/questions/2539961/error-access-denied-for-user-mysql-server">Error Access denied for user MySQL server?</a></p>
  
  <p>But my question I think is different. So I have set up a linked server and it works. I have the correct permissions set up for my IP's that I am using.  However the problem arises when our user "webuser@correctIP" tries to access it. Therefore, any user using window authentication is allowed to access it and works great. But any that are not using windows authentication are blocked.  </p>
  
  <p>However, I have tried all the common solutions such as setting up a strict password, changing security settings in Microsoft SQL Server etc. Nothing is working.</p>
  
  <p>FYI: I am using this from Microsoft SQL Server 2008 -> mysql (through phpMyAdmin)</p>