Differences

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

--- mysql_management [2018/09/27 14:34]
root created
+++ mysql_management [2018/09/27 15:10] (current)
root
@@ Line 5: / Line 5: @@
 The MySQL databases are dumped to disk weekly and the dumps are backed up to the HPC backup space.
+==== 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). 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