$ mysqldump -u[사용자아이디] -p [데이터베이스명]> [저장될 파일명]
$ mysqldump -utester -p dbtest > test.sql #예

$ mysqldump -u[사용자아이디] -p [데이터베이스명] [테이블명] > [저장될 파일명]

$ mysql -u[사용자아이디] -p [디비명] < [덤프파일명]

SELECT id, label FROM labels ORDER BY IF (updated_at > created_at, updated_at, created_at) desc

mysql -uroot -p

mysql> use mysql;
mysql> select host, user, password from user;

mysql> grant all privileges on *.* to ‘root’@‘192.168.56.101’ identified by ‘root의 패스워드’;

mysql> grant all privileges on *.* to ‘root’@‘192.168.%’ identified by ‘root의 패스워드’;

mysql> grant all privileges on *.* to ‘root’@‘%’ identified by ‘root의 패스워드’

mysql> select host, user, password from user;
mysql> flush privileges;

vi /etc/my.cnf
# bind-address = 127.0.0.1

/etc/init.d/mysqld restart

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

mysql> set time_zone = 'Asia/Seoul';
mysql> select @@time_zone;
mysql> select now();

service mysqld restart