mysql如果不是用root帐户登陆的话,只能看到对应的有权限的数据库的,你最好用root登陆然后再 show database
应该是编码不对!可以用下面方法试一下 1、在my.ini(linux my.cnf)下,设置[mysql] default-character-set=gb23122、用show variables like "character_set_%";显示如下mysql> show variables like "character_set_%"; +--------------------------+---------------------------------------------------+| Variable_name | Value |+--------------------------+---------------------------------------------------+| character_set_client | gb2312 || character_set_connection | gb2312 || character_set_database | latin1 || character_set_filesystem | binary || character_set_results | gb2312 || character_set_server | latin1 || character_set_system | utf8 || character_sets_dir | C:\Program Files\MySQL Server 5.0\share\charsets\ |+--------------------------+---------------------------------------------------+8 rows in set (0.00 sec)3、导入时要设置character set utf8,语句如下;mysql> load data local infile 'c://1.csv' into table `chgx`.`tbl_user` character set utf8 fields escaped by '\\' terminated by ',' optionally enclosed by '"' lines terminated by '\r\n' (`telephone`, `PASSWORD`,`username`);(注意导入文件存为ansi时,字符集要设为character set gb2312;导入文件为存为utf-8格试时,字符集要设为character set utf8)
MySQL 中文显示乱码
这个,,,看看直接select其它9个数据库中的表,有什么效果?
mysql如果不是用root帐户登陆的话,只能看到对应的有权限的数据库的,你最好用root登陆然后再
show database
1、在my.ini(linux my.cnf)下,设置[mysql]
default-character-set=gb23122、用show variables like "character_set_%";显示如下mysql> show variables like "character_set_%";
+--------------------------+---------------------------------------------------+| Variable_name | Value |+--------------------------+---------------------------------------------------+| character_set_client | gb2312 || character_set_connection | gb2312 || character_set_database | latin1 || character_set_filesystem | binary || character_set_results | gb2312 || character_set_server | latin1 || character_set_system | utf8 || character_sets_dir | C:\Program Files\MySQL Server 5.0\share\charsets\ |+--------------------------+---------------------------------------------------+8 rows in set (0.00 sec)3、导入时要设置character set utf8,语句如下;mysql> load data local infile 'c://1.csv' into table `chgx`.`tbl_user` character set utf8 fields escaped by '\\' terminated by ',' optionally enclosed by '"' lines terminated by '\r\n' (`telephone`, `PASSWORD`,`username`);(注意导入文件存为ansi时,字符集要设为character set gb2312;导入文件为存为utf-8格试时,字符集要设为character set utf8)