653
edits
Changes
Jump to navigation
Jump to search
Line 4:
Line 4: − + + Line 92:
Line 93: − ## 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>+
no edit summary
*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==
<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===