[sisyphus] mysql 5.0.34 charsets

Serge =?iso-8859-1?q?serg-e_=CE=C1_ukr=2Enet?=
Чт Май 17 15:21:24 MSD 2007


Доброго дня.

Обнаружил интересную ситуацию:
есть 2 машинки с сизифом.
на обоих стоит mysql 5.0.34 "из коробки", тоесть apt-get install ...
m1
# mysql mysql
mysql> status
...
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
=========================

m2
# mysql mysql
mysql> status

Server characterset:    koi8r
Db     characterset:    koi8r
Client characterset:    latin1
Conn.  characterset:    latin1
=========================

ручками нигде конфиги не трогал.
m1
$ rpm -qa|grep MySQL

MySQL-client-5.0.34-alt1
libMySQL-5.0.34-alt1
MySQL-server-5.0.34-alt1

cat /etc/sysconfig/mysqld
# custom server charset
CHSET=
# other server opts
OPT=


# cat /var/lib/mysql/my.cnf
[mysqld]
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# FIXME! bdb maybe work on x86/Linux and amd64/Linux
#skip-bdb
chroot=/var/lib/mysql
datadir=/db
bdb-logdir=/log
log=/log/queries
pid-file=/mysqld.pid
skip-locking
skip-networking
socket=/mysql.sock
tmpdir=/tmp
user=mysql
===============================================

m2
$ rpm -qa|grep MySQL

MySQL-client-5.0.34-alt1
libMySQL-5.0.34-alt1
MySQL-server-5.0.34-alt1

cat /etc/sysconfig/mysqld
# custom server charset
CHSET=
# other server opts
OPT=


# cat /var/lib/mysql/my.cnf
[mysqld]
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# FIXME! bdb maybe work on x86/Linux and amd64/Linux
#skip-bdb
chroot=/var/lib/mysql
datadir=/db
bdb-logdir=/log
#log=/log/queries
pid-file=/mysqld.pid
skip-locking
skip-networking
socket=/mysql.sock
tmpdir=/tmp
user=mysql


как все таки должно быть и как исправить ситуацию???




Подробная информация о списке рассылки Sisyphus