ALT Linux Community general discussions
 help / color / mirror / Atom feed
From: "Dodelup" <altlinux@vipdesign.ru>
To: <community@altlinux.ru>
Subject: [Comm] Lost connection to MySQL server during query
Date: Mon, 31 Mar 2003 01:16:35 +0400
Message-ID: <001b01c2f701$b2a3c360$a8a8a8c0@eika> (raw)

Господа!

Детский наверное вопрос, но все таки...

По локалке пытаюсь с машины 192.168.168.168 подключиться к машине
192.168.168.5, а точнее к ее MySQL-серверу (для этого использую
PHPMyAdmin).

При попытке обратиться к БД MySQL-сервер посылает меня подальше такими
словами: Lost connection to MySQL server during query.

При этом в /var/log/mysql.log по делу ИМХО ничего не пишет:

***
Number of processes running now: 1
mysqld process hanging, pid 566 - killed
030331 00:14:04  mysqld restarted
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections
***

Ошибок в конфиге PHPMyAdmin скорее всего тоже нет, потому как с другими
MySQL-серверами работаю без проблем. Но на всякий случаю даю кусок
конфига:

***
$cfg['Servers'][$i]['host']          = '192.168.168.5';
$cfg['Servers'][$i]['port']          = '';
$cfg['Servers'][$i]['socket']        = '';
$cfg['Servers'][$i]['connect_type']  = 'tcp';
$cfg['Servers'][$i]['compress']      = FALSE;
$cfg['Servers'][$i]['controluser']   = '';
$cfg['Servers'][$i]['controlpass']   = '';
$cfg['Servers'][$i]['auth_type']     = 'config';
$cfg['Servers'][$i]['user']          = 'test';
$cfg['Servers'][$i]['password']      = 'mypass';
$cfg['Servers'][$i]['only_db']       = '';
***

Пользователь test существует в системе и занесен в таблицу mysql
командой:

***
insert into user (host,user,password) values ('localhost', 'test',
password('mypass'));
insert into db
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_pri
v,
Drop_priv,Grant_priv,References_priv,Index_priv,Alter_priv) values
('localhost','test1','test','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); 
flush privileges;
***

В чем грабли?

P.S.
Что еще странно, так это то, что в БД mysql у пользователя test вместо
Y,Y,Y,Y,Y,Y,Y,Y,Y,Y значатся N,N,N,N,N,N,N,N,N,N. 

--
Dodelup

             reply	other threads:[~2003-03-30 21:16 UTC|newest]

Thread overview: 33+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2003-03-30 21:16 Dodelup [this message]
2003-03-31 18:58 ` Dodelup
2003-04-01  3:18   ` Maxim.Savrilov
2003-04-01 20:14     ` Dodelup
2003-04-01 22:27       ` Dodelup
2003-04-02  3:21       ` Maxim.Savrilov
2003-04-02 22:41         ` Dodelup
2003-04-03 19:15           ` Dodelup
2003-04-04  2:27             ` Maxim.Savrilov
2003-04-04  7:46               ` Dodelup
2003-04-04  8:13                 ` Maxim.Savrilov
2003-04-04  9:21                   ` Dodelup
2003-04-04 10:09                     ` Maxim.Savrilov
2003-04-04 10:16                       ` Dodelup
2003-04-04 10:56                         ` Maxim.Savrilov
2003-04-04 19:48                           ` Dodelup
2003-04-05 13:12                   ` [Comm] bootsplash & 1024x768 S.Tertychniy
2003-04-07 18:48                     ` Vadim V. Zhytnikov
2003-04-08 15:35                       ` Sergey Tertichniy
2003-04-08 16:49                         ` Re[2]: " ASA
2003-04-08 18:05                           ` Sergey Tertichniy
2003-04-09  2:34                             ` Re[4]: " ASA
2003-04-09 11:39                         ` [Comm] " Sergey Vlasov
2003-04-04  7:07             ` [Comm] Lost connection to MySQL server during query Igor Muratov
2003-04-04  7:52               ` Dodelup
2003-04-04  8:14                 ` Igor Muratov
2003-04-04  9:30                   ` Yura Kalinichenko
2003-04-04  9:37                   ` Dodelup
2003-04-04 10:02                   ` Dmitry Nikitin
2003-04-06 21:34                   ` Dodelup
2003-04-08 17:51                     ` Dodelup
2003-04-09 15:58                       ` [Comm] " Michael Shigorin
2003-04-09 15:54           ` Michael Shigorin

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='001b01c2f701$b2a3c360$a8a8a8c0@eika' \
    --to=altlinux@vipdesign.ru \
    --cc=community@altlinux.ru \
    /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 Community general discussions

This inbox may be cloned and mirrored by anyone:

	git clone --mirror http://lore.altlinux.org/community/0 community/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 community community/ http://lore.altlinux.org/community \
		mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com
	public-inbox-index community

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


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