coremail mysql_mysql 常用操作记录。

mysql 常用操作

1、登陆mysql查看表信息时，为了防止中文出现乱码

修改下面脚本：

#vi /home/coremail/bin/mysql_cm

#!/bin/sh

/home/coremail/mysql/bin/mysql -ucoremail -p3376211849 -h127.0.0.1 -P3308 cmxt --default-character-set=gbk

mysql> show variables like '%char%';

+--------------------------+--------------------------------------------+

| Variable_name            | Value                                      |

+--------------------------+--------------------------------------------+

| character_set_client     | gbk                                        |

| character_set_connection | gbk                                        |

| character_set_database   | latin1                                     |

| character_set_results    | gbk                                        |

| character_set_server     | latin1                                     |

| character_set_system     | utf8                                       |

| character_sets_dir       | /home/coremail/mysql/share/mysql/charsets/ |

+--------------------------+--------------------------------------------+

给root用户设置密码

#mysqladmin -u root password '123456'