Differences

This shows you the differences between two versions of the page.

--- mysql_management [2018/09/27 14:46]
root
+++ mysql_management [2018/09/27 15:10] (current)
root
@@ Line 12: / Line 12: @@
 show databases;
 create database DATABASENAME;
-create user 'username'@'node%' identified by 'password';
+create user 'USERNAME'@'node%' identified by 'PASSWORD';
+grant all privileges on DATABASENAME . * TO 'username'@'node%';
+</code>
+To access the new database, the user would then use this command (from the head node):
+<code>
+mysql -p -h fs1 -u USERNAME DATABASENAME
 </code>

BRC Cluster Workshop