Difference between revisions of "MySQL"
From Nuclear Physics Group Documentation Pages
Jump to navigationJump to search| Line 4: | Line 4: | ||
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]]. | ||
| + | |||
| + | 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; | ||
<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> | ||
Revision as of 16:28, 27 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;
PLEASE TAKE EXTREME CARE WITH USER PERMISSIONS!
