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!
