JB blog

# root암호설정 - root로 로그인하여 해야함 % mysqladmin -u root password '변경암호' % mysqladmin -u root -p기존암호 password '변경암호' root암호변경설정 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h ns.moyiza.net -p password 'new-password' DB작업 DB생성: mysql> create database DB명 ( or % mysqladmin -u root -p crea..

mysql> desc common_pivot -> ; +--------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+----------+------+-----+---------+----------------+ | seq_id | int(11) | NO | PRI | NULL | auto_increment | | seq_nm | char(32) | YES | | NULL | | +--------+----------+------+-----+---------+----------------+ select reverse(substring(reverse(substr..

mysqld_safe --log-slow-queries &