MySQL
From Nuclear Physics Group Documentation Pages
Jump to navigationJump to searchTo be further documented.
Main documentation: http://dev.mysql.com/doc/
Restore procedure used for upgrade from MySql 4.1 to 5.0.x Mysql database restore.
Create Users in MySQL CREATE USER some_user@'%.unh.edu' IDENTIFIED BY 'some_pass';
Create Database CREATE database some_datadb;
Give user permission to specific database GRANT ALL ON some_datadb.* TO some_user@'%.unh.edu';
Check user permissions use mysql; SELECT * FROM user;
PLEASE TAKE EXTREME CARE WITH USER PERMISSIONS!
