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
next 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