ALT Linux Sisyphus discussions
 help / color / mirror / Atom feed
From: Serge <serg-e@ukr.net>
To: ALT Linux Sisyphus discussion list <sisyphus@lists.altlinux.org>
Subject: [sisyphus] mysql 5.0.34 charsets
Date: Thu, 17 May 2007 14:21:24 +0300
Message-ID: <464C3AB4.7020104@ukr.net> (raw)

Доброго дня.

Обнаружил интересную ситуацию:
есть 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


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



             reply	other threads:[~2007-05-17 11:21 UTC|newest]

Thread overview: 4+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2007-05-17 11:21 Serge [this message]
2007-05-17 15:42 ` Andrew Kornilov
2007-05-18  8:12   ` Serge
2007-05-19 13:00     ` Andrew Kornilov

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=464C3AB4.7020104@ukr.net \
    --to=serg-e@ukr.net \
    --cc=sisyphus@lists.altlinux.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

ALT Linux Sisyphus discussions

This inbox may be cloned and mirrored by anyone:

	git clone --mirror http://lore.altlinux.org/sisyphus/0 sisyphus/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 sisyphus sisyphus/ http://lore.altlinux.org/sisyphus \
		sisyphus@altlinux.ru sisyphus@altlinux.org sisyphus@lists.altlinux.org sisyphus@lists.altlinux.ru sisyphus@lists.altlinux.com sisyphus@linuxteam.iplabs.ru sisyphus@list.linux-os.ru
	public-inbox-index sisyphus

Example config snippet for mirrors.
Newsgroup available over NNTP:
	nntp://lore.altlinux.org/org.altlinux.lists.sisyphus


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git