Re: lug-bg: mysql remote connection problem

[kal_pav@email.domain.hidden (Pavel Minev Penev)]

On Thu, Jun 05, 2003 at 09:08:13AM +0300, Tosho Yankov wrote:
<em class="quotelev1">> Purvo da se izvinq che ne sym dal pulno info za mashinata. eto go>
<em class="quotelev1">> Distrib - slackware 8.1 (i na dvete mashini)
<em class="quotelev1">> 
<em class="quotelev1">> ( uslovno ste nareka mashinite taka :
<em class="quotelev1">> tazi na koqto iskam da se zakacha server, a drugata ot koqto se
<em class="quotelev1">> opitvam da se zakacha klient )
<em class="quotelev1">> server :
<em class="quotelev1">>  mysqladmin -p version
<em class="quotelev1">> Enter password:
<em class="quotelev1">> mysqladmin  Ver 8.23 Distrib 3.23.51, for slackware-linux-gnu on i386
<em class="quotelev1">> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
<em class="quotelev1">> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
<em class="quotelev1">> and you are welcome to modify and redistribute it under the GPL license
<em class="quotelev1">> 
<em class="quotelev1">> Server version          3.23.51-log
<em class="quotelev1">> Protocol version        10
<em class="quotelev1">> Connection              Localhost via UNIX socket
<em class="quotelev1">> UNIX socket             /var/run/mysql/mysql.sock
<em class="quotelev1">> Uptime:                 1 day 16 hours 6 min 3 sec
<em class="quotelev1">> 
<em class="quotelev1">> Threads: 1  Questions: 122305  Slow queries: 0  Opens: 2466  Flush tables:
<em class="quotelev1">> 1  Open tables: 4 Queries per second avg: 0.847
<em class="quotelev1">> 
<em class="quotelev1">> klinet:  mysql -V
<em class="quotelev1">> mysql  Ver 11.18 Distrib 3.23.51, for slackware-linux-gnu (i386)
<em class="quotelev1">> 
<em class="quotelev1">> eto rezulatat ot telnet server 3306:
<em class="quotelev1">> 
<em class="quotelev1">> telnet free 3306
<em class="quotelev1">> Trying 217.xxx.xxx.xxx...
<em class="quotelev1">> Connected to free.
<em class="quotelev1">> Escape character is '^]'.
<em class="quotelev1">> Connection closed by foreign host.
<em class="quotelev1">> 
<em class="quotelev1">> t.e. otvoren e port 3306 na servera za clienta.
<em class="quotelev1">> 
<em class="quotelev1">> eto i tablicata user na servera:
<em class="quotelev1">> (tova e izhod ot mysqldump)
<em class="quotelev1">> INSERT INTO user VALUES ('client','root','xxxxxxxxxxxxxxxxxx','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
<em class="quotelev1">>                            ^^^^              ^^^^^^^^^^^^^
<em class="quotelev1">> v /etc/hosts na servera e opisana taka        parolata si e normalno
<em class="quotelev1">>                                               az sym slojil tez xxxxx
<em class="quotelev1">> 
<em class="quotelev1">> ami .. dano sym dal pulno info.

Mozhe li konfguracionniq file/opciite, s koito startirash `mysqld`?
(Vizh da ne si zabravil da mahnesh "--skip-networking").

+,

-- 
Pav
                             ,.,
                           ,``:'',
Gain your human right of   {o ! o}  My GPG/PGP key is now available at
privacy: use cryptography! ] -+- [  x-hkp://search.keyserver.net:11371.
                            \ ! /
                             `-'
`shell$ gpg --keyserver x-hkp://search.keyserver.net:11371 --recv-key 164C028F`
http://www.againsttcpa.com/index.shtml



============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================

<hr>

Attachment: part
Description: PGP signature