2,306
edits
Changes
Jump to navigation
Jump to search
mLine 34:
Line 34: − + + + + + +
→Create User
mysql -h20.1.40.66 -u xe50582 -p -D workflow -e "SELECT hostname FROM controles_sistemas WHERE cod_plataforma='UNX'" > hostnames_unix_workflow.txt
mysql -h20.1.40.66 -u xe50582 -p -D workflow -e "SELECT hostname FROM controles_sistemas WHERE cod_plataforma='UNX'" > hostnames_unix_workflow.txt
=== Create User ===
===Create User===
<syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
CREATE USER 'owncloud'@'localhost' IDENTIFIED BY 'password';
CREATE USER 'owncloud'@'localhost' IDENTIFIED BY 'password';
</syntaxhighlight>
=== Grant Access to Database ===
<syntaxhighlight lang="sql">
GRANT ALL ON owncloud.* TO 'ownclouduser'@'localhost' IDENTIFIED BY '4yRQpHDju5WdecKp8WrK' WITH GRANT OPTION;
</syntaxhighlight>
</syntaxhighlight>