Difference between revisions of "MySQL"

From Nuclear Physics Group Documentation Pages
Jump to navigationJump to search
 
Line 17: Line 17:
 
   use mysql;
 
   use mysql;
 
   SELECT * FROM user;
 
   SELECT * FROM user;
 +
 +
On Roentgen in /etc/my.cnf this line was added specifically for Transana
 +
  set-variable=max_allowed_packet=8500000
  
 
<font size="+2" color=red><b>PLEASE TAKE EXTREME CARE WITH USER PERMISSIONS!</b></font>
 
<font size="+2" color=red><b>PLEASE TAKE EXTREME CARE WITH USER PERMISSIONS!</b></font>

Latest revision as of 15:47, 29 April 2010

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!