SeanFromIT Posted January 21, 2007 Share Posted January 21, 2007 Does anyone know how to stop the MySQL GUI tools from adding @yourhostname to the username that you type in the prompt?Example: I type in correct username "user"MySQL GUI Tools Connection errors out saying "user@ip.verizon.city.etc denied"The denial is coming from the fact that it's adding @blahblah to my username. Quote Link to comment Share on other sites More sharing options...
printf Posted January 21, 2007 Share Posted January 21, 2007 [quote]The denial is coming from the fact that it's adding @blahblah to my username.[/quote]No it's not, the problem is that your MySQL user table does not match the user. MySQL will always include @remote_host in the error or connection information. It has nothing to do with the real problem. If you setup a user, and that user is going to connect remotely, then you need to set the 'user' [b]Host[/b], to the [b]IP[/b] that will be connecting to the MySQL server. If the [b]IP[/b] is dynamic, or could change, then use [code]%[/code] a percent sign in the MySQL 'user' table column [code]Host[/code]. So any IP can connect, as long as they know the correct username and password!printf Quote Link to comment Share on other sites More sharing options...
SeanFromIT Posted January 21, 2007 Author Share Posted January 21, 2007 Thanks! You're correct. I added % wildcard to my Access Hosts list and now I can remotely connect! :-) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.