Allow access from Hoststar branch office
Aus HS Syswiki
(Unterschied zwischen Versionen)
Vkl (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „<syntaxhighlight lang="bash" style="font-size:9pt;"> CREATE USER 'root'@'ptr-mn-fbr.loginserver.ch' IDENTIFIED BY 'FILL-PASSWORD'; CREATE USER 'root'@'84.253.1…“) |
Vkl (Diskussion | Beiträge) |
||
Zeile 11: | Zeile 11: | ||
-A INPUT -s 84.253.15.193 -p tcp --dport 3306 -j ACCEPT | -A INPUT -s 84.253.15.193 -p tcp --dport 3306 -j ACCEPT | ||
</syntaxhighlight> | </syntaxhighlight> | ||
+ | |||
+ | [[Category:MySQL]] |
Version vom 17. Juni 2014, 15:25 Uhr
CREATE USER 'root'@'ptr-mn-fbr.loginserver.ch' IDENTIFIED BY 'FILL-PASSWORD'; CREATE USER 'root'@'84.253.15.193' IDENTIFIED BY 'FILL-PASSWORD'; GRANT ALL PRIVILEGES ON * . * TO 'root'@'ptr-mn-fbr.loginserver.ch'; GRANT ALL PRIVILEGES ON * . * TO 'root'@'84.253.15.193'; FLUSH PRIVILEGES; # allow access in IP tables -A INPUT -s 84.253.15.193 -p tcp --dport 3306 -j ACCEPT