'IT노트/MYSQL' 카테고리의 글 목록 (25 Page)

참고 DB 생성

IT노트/MYSQL 2015. 2. 14. 18:09

create database redmine character set utf8;

mysql> create user 'redmine'@'localhost' identified by 'my_password';

mysql> create user 'redmine'@'%' identified by 'my_password';

mysql> grant all privileges on redmine.* to 'redmine'@'localhost';

mysql> grant all privileges on redmine.* to 'redmine'@'%';
mysql> \q

Hierarchical data in MySQL: parents and children in one query \| EXPLAIN EXTENDED (0)	2015.02.16
MySQL 프로시저(Procedure) (0)	2015.02.16
Incorrect string value 에러 : alter TABLE INC_ACT_INFO modify column ACT_CONTENT text character set utf8 collate utf8_general_ci; (0)	2015.02.16
Access denied for user 'root'@'localhost' (using password: YES) (0)	2015.02.14
CentOS 6.3 + MySQL 5.6.17 RPM 설치 (0)	2015.01.26