싸이언의 휴식공간

갑자기 mysql 데몬이 올라오지 않음. 로그 확인]# cat /var/log/mysqld.log 2016-09-06 03:31:51 0 [Note] /usr/sbin/mysqld (mysqld 5.6.31) starting as process 6388 ...2016-09-06 03:31:52 6388 [Note] Plugin 'FEDERATED' is disabled.2016-09-06 03:31:52 6388 [Note] InnoDB: Using atomics to ref count buffer pool pages2016-09-06 03:31:52 6388 [Note] InnoDB: The InnoDB memory heap is disabled2016-09-06 03:31:52 6388 [Note] ..

MySQL 원격접속 가능하도록 IP추가하기 mysql> insert into mysql.user (host, user, password, ssl_cipher, x509_issuer, x509_subject) values ('접속자아이피', 'DB계정', password('암호'), '', '', ''); mysql> insert into mysql.user (host, user, password, ssl_cipher, x509_issuer) values ('접속자아이피', 'DB계정', password('암호'), '', '');ERROR 1364 (HY000): Field 'x509_subject' doesn't have a default valuemysql> insert into mysql.user ..

컬럼 기본값을 현재시간으로 넣기출처 : http://alvinalexander.com/mysql/mysql-default-date-now-current-date-timemysql> create table test (foo int, ts timestamp default now()); Query OK, 0 rows affected (0.20 sec) mysql> desc test; +-------+-----------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+-----+-------------------+-------+ | foo | int..