Differences

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

--- mysql_management [2018/09/27 14:44]
root
+++ mysql_management [2018/09/27 15:10] (current)
root
@@ Line 7: / Line 7: @@
 ==== New Database and User ====
-To create a new database for a specific user, log in to the file server and run mysql (the MySQL root password is configured in .my.cnf, so you will log on automatically).
+To create a new database for a specific user, log in to the file server and run mysql (the MySQL root password is configured in .my.cnf, so you will log on automatically). In the "create user" command below, the 'node%' is literal and means: "all hosts with names starting with **node**".
 <code>
 show databases;
 create database DATABASENAME;
+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