653
edits
Changes
From SME Server
Jump to navigationJump to searchno 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===
