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!
