Difference between revisions of "MySQL"

From Nuclear Physics Group Documentation Pages
Jump to navigationJump to search
 
(3 intermediate revisions by 2 users not shown)
Line 5: Line 5:
 
Restore procedure used for upgrade from MySql 4.1 to 5.0.x [[Mysql database restore]].
 
Restore procedure used for upgrade from MySql 4.1 to 5.0.x [[Mysql database restore]].
  
<font size="+2" color=red><b>PLEASE TAKE EXTREME CARE WITH USER PERMISSIONS!<b></font>
+
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
 +
 
 +
<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!