2,411
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 82:
Line 82: − +
Added tip to suggest to use hostname over IP in certain cases
==== Allow mysql login from any LAN workstation ====
==== Allow mysql login from any LAN workstation ====
Assuming your local network is 192.168.xx.0, you can create a user with mysql access from any LAN workstation (or VPN client) using the command shown below (couresy of [http://forums.contribs.org/index.php/topic,32270.msg136322.html#msg136322 DarkMirage]).
Assuming your local network is 192.168.xx.0, you can create a user with mysql access from any LAN workstation (or VPN client) using the command shown below (couresy of [http://forums.contribs.org/index.php/topic,32270.msg136322.html#msg136322 DarkMirage]).
{{Tip box|The suggestion here is to assign privileges based on IP number (using a wild card if desired), the same can also be done for hostnames. In some cases, like dynamicaly assgned IP addresses, this might be a more suitable and robust solution.}}
You probably want to change:
You probably want to change:
* the database name ('''MyDB''')
* the database name ('''MyDB''')
