1.导出
C:\Users\Administrator>mysqldump --opt -u root -p game_release > c:\game_release
_table.sql
导入
create databases game_release
[mysql bin path]>mysql -uroot -p game_release < game_release_table.sql
授权
mysql>grant all privileges on game_release.* to game@'ip' identified by '123456';
mysql>flush privileges;
mysql>grant all privileges on game_release.* to game@'localhost' identified by '123456';
mysql>flush privileges;
2. mysql 字符编码修改
mysql> show variables like "%char%";
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
在配置文件[client]中加入
default-character-set = latin1 结果如下
mysql> show variables like "%char%";
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
3.linux下设置mysql不区分表名大小写(win下不区分）
a)linux下mysql安装完后是默认：区分表名的大小写，不区分列名的大小写；
b)、用root帐号登录后，在/etc/my.cnf 中的[mysqld]后添加添加lower_case_table_names=1，
重启MYSQL服务，这时已设置成功：不区分表名的大小写；
c) lower_case_table_names参数详解：
lower_case_table_names = 0 其中 0：区分大小写，
1：不区分大小写 MySQL在Linux下数据库名、表名、列名、别名大小写规则是这样的：
1、数据库名与表名是严格区分大小写的；
2、表的别名是严格区分大小写的；
3、列名与列的别名在所有的情况下均是忽略大小写的；
4、变量名也是严格区分大小写的；
注意：MySQL在Windows下都不区分大小写。
