[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