Timeline for Can not connect to MySql server remotely
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 13, 2015 at 7:05 | history | migrated | from stackoverflow.com (revisions) | ||
| Feb 11, 2015 at 20:01 | comment | added | Jamey D | Yes, just re-add the user you want with the same password multiple times for different hosts/IP's. | |
| Feb 11, 2015 at 19:59 | comment | added | Eunice | is there any way to specify a range of ip's that should connect to the database through that user? | |
| Feb 11, 2015 at 19:58 | comment | added | Eunice | thanks alot it worked. u said using the wildcard % for the host field, for a user is not recommended in a production environment, please why, what are the implication. | |
| Feb 11, 2015 at 18:29 | comment | added | bluecollarcoder |
To expand on this answer, the way to see where a user can connect from, do a show grants for <user> command. You will see the permission being granted to '<user>'@'<host>'. You want to make sure that the <host> is '%' and not 'localhost'.
|
|
| Feb 11, 2015 at 17:43 | history | answered | Jamey D | CC BY-SA 3.0 |