MySQL

From Nuclear Physics Group Documentation Pages
Jump to navigationJump to search

To 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;

On Roentgen in /etc/my.cnf this line was added specifically for Transana

 set-variable=max_allowed_packet=8500000

PLEASE TAKE EXTREME CARE WITH USER PERMISSIONS!