Using TOAD on WinXP client and can not connect to mysql on remote linux (redhat) server. Error: Access denied for user 'dlw27'@clientname. Why does error msg show 'client' machine name instead of host server name I typed in? Verified dlw27@servername valid user in mysql (user table within mysql DB). Verified port 3306 listening for TCP (used portqry utility).
The client name is displayed because that is how the user security is setup in MySQL: users are authorized when connecting from a certain location (in this case, from 'clientname'). This prevents someone from trying to connect from any server. In many cases, I restrict connection to localhost, or to the IP address of the server on which my database is, so that no one, not even me, can connect from another location.