Timeline for mysql user creation with % to host , can only log on from remote host
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 16, 2012 at 18:24 | comment | added | atxdba | Security. If you only want a user to connect via localhost then specify @'localhost' in the grant. Using '%' potentially allows connections from any internet address (assuming your port is open to that). It's more prudent to restrict the credentials to your network. e.g. 'user'@'10.1.%' | |
| Jan 16, 2012 at 18:16 | comment | added | Tom Gee | how so? what would be the correct syntax to add users in that case? | |
| Jan 16, 2012 at 18:14 | comment | added | atxdba | It's worth pointing out this is probably bad practice for production configurations. | |
| Jan 16, 2012 at 18:12 | comment | added | Tom Gee | Thanks that did it. Strange on Ubuntu it seems to work without the --proto=TCP but on RHEL I guess you need it. | |
| Jan 16, 2012 at 18:09 | history | answered | atxdba | CC BY-SA 3.0 |