653
edits
Changes
From SME Server
Jump to navigationJump to searchno edit summary
Line 4:
Line 4:
## Either include them, or place the entire command on one line+ mysql -e "\+ create database MyDB; \+ GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER \+ ON *.* \+ TO 'MyUser'@'192.168.xx.%' \+ IDENTIFIED BY 'MyPW'; \+ FLUSH PRIVILEGES;"</nowiki>+
*MySQL website: http://www.mysql.com <br />
*MySQL website: http://www.mysql.com <br />
−*MySQL 4.1 manual: http://dev.mysql.com/doc/refman/4.1/en/
+*MySQL 4.1 manual: http://dev.mysql.com/doc/refman/4.1/en/<br />
+*MariaDB documentation: https://mariadb.org/documentation/
==General==
==General==
Line 92:
Line 93:
<nowiki>## In the command below, \ escapes a linebreak.
<nowiki>## In the command below, \ escapes a linebreak.
− ## Either include them, or place the entire command on one line
− mysql -e "\
− create database MyDB; \
− GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER \
− ON *.* \
− TO 'MyUser'@'192.168.xx.%' \
− IDENTIFIED BY 'MyPW'; \
− FLUSH PRIVILEGES;"</nowiki>
===Security Implications of allowing remote mysql login===
===Security Implications of allowing remote mysql login===
