mysqladmin -u root password "passwd"

-- 导出整个库
mysqldump -uroot -ppassword -P3306 -h127.0.0.1 --default-character-set=utf8 --result-file=test.sql test
-- 导出表
mysqldump -uroot -ppassword -P3306 -h127.0.0.1 --default-character-set=utf8 --result-file=test.sql test table1 table2
-- 导出表结构
mysqldump -d -uroot -ppassword -P3306 -h127.0.0.1 --default-character-set=utf8 --result-file=test.sql test table1
-- 导入数据
mysql -uroot -ppassword -P3306 -h127.0.0.1 test < test.sql
-- 导入csv数据
mysql -uroot -p123456 -Dsampledata -e "load data local infile 'date.txt' into table time_day columns terminated by ',' lines terminated by '\n'"

[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

sudo /etc/init.d/mysqld stop
cd /var/lib
sudo tar -zcvf mysql.tar.gz mysql
sudo mkdir -p /data/mysql
sudo chown -R mysql.mysql /data/mysql
sudo su mysql
cd /data/mysql
cp /var/lib/mysql.tar.gz .
tar -zxvf mysql.tar.gz
mv mysql data
exit

[mysqld]
#datadir=/var/lib/mysql
datadir=/data/mysql/data

$ sudo rpm -Uvh platform-and-version-specific-package-name.rpm
$ sudo yum install mysql-community-server
$ sudo mysqld_safe --skip-grant-tables >/dev/null 2>&1 &
$ mysql -u root mysql
mysql> update user set password = Password('your_password') where user = 'root';
mysql> flush privileges;
mysql> exit;

alter table t1 rename t2;
alter table t add col1 int;
alter table t drop column col1;
alter table t modify column col1 varchar(50) after col2;
alter table t change col1 col2 int;
alter table t change col1 col1 bigint not null;
alter table t add index idx_name (col1, col2);
alter table t drop index idx_name;

sudo service mysql start