Zdraveite! Predi vreme si instalirah mysql server. Dosta
 vreme sum go izpolzval bez nikakuv problem ot localnata
 mashina. Tazi vecher reshih ot druga mashina da se connectna
 kum mysql servera. Opita beshe neuspeshen. Prichinata za
 tova e che myqld ne otvarq port 3306 koito e standarten a
 samo izgrajda socket za connekciq prez koito se izvurshvat
 connekciite ot localnata mashina. Kak da nakaram tozi mysqld
 da si otvori porta 3306. vuv faila /etc/mysql/my.cnf vsichko
e nared. Eto chast ot log-a:

Tcp port: 0  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
030821  6:25:46     565 Quit
030822  1:46:45     566 Connect     root@localhost on
                    566 Init DB     nuke
                    566 Init DB     nuke

 ot tuk se vijda che port 3306 ne se otvarq. Probvah s
 safe_mysqld --port=#3306 i tova ne pomogna. Nadqvam se vie
da mi pomognete! BLagodarq!!!

 simvolyt '#' se izpolzva za komentar pri povecheto shellove.
probvai bez nego.

Problama ti e #

 Mersi che mi otgovorihte. Samo che problema ne e v tova.
 Razbira se probvah bez # no efekta e sushtiqt. Inache kogato
napisha safe_mysqld --port=3306 se poqvqva:

zmeio:/etc/init.d# ./mysql stop
Stopping MySQL database server: mysqld.
zmeio:/etc/init.d# safe_mysqld --port=3306
Starting mysqld daemon with databases from /var/lib/mysql

 i do tuk, konzolata ostava v takova polojenie i nito s
 CTRL+C, CTRL+D, CTRL+Z mogat da q nakarat da premine otnovo
 v commanden rejim. Shte dam malko info za distribuciqta. Tq
e Debian 3.0 r1 woody.
 Ako problema ne se opravi sledvashtata stupka shte e
 izteglqne na mysql v source kod i kompilirane, no bih iskal
da probvam vsichko vuzmojno predi da predpriema tova!

 Разгледай /etc/my.cnf, там може да откриеш проблема. Ако все
 пак не успееш що не пренасочиш порта с iptables - отчаян
ход, но май ще свърши работа.

 Eto config faila. Shte sum blagodaren ako nqki otkrie kude v
nego e priblema:

xxx@xxx:/etc/mysql$ cat my.cnf
# You can copy this to one of:
# /etc/mysql/my.cnf to set global options,
 # mysql-data-dir/my.cnf to set server-specific options (in
this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can use all long options that the program supports.
 # Run the program with --help to get a list of available
options

# This will be passed to all mysql clients
[client]
#password       = my_password
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

[safe_mysqld]
err-log         = /var/log/mysql/mysql.err

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
#
 # You can also put it into /var/log/mysql/mysql.log but I
leave it in /var/log
 # for backward compatibility. Both location gets rotated by
the cronjob.
#log            = /var/log/mysql/mysql.log
log             = /var/log/mysql.log
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-locking
#
 # The skip-networkin option will no longer be set via
debconf menu.
 # You have to manually change it if you want networking i.e.
the server
 # listening on port 3306. The default is "disable" - for
security reasons.
skip-networking
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = thread_stack=128K
#
# Here you can see queries with especially long duration
#log-slow-queries       = /var/log/mysql/mysql-slow.log
#
 # The following can be used as easy to replay backup logs or
for replication
#server-id              = 1
#log-bin                = /var/log/mysql/mysql-bin.log
#binlog-do-db           = include_database_name
#binlog-ignore-db       = include_database_name
#
# Read the manual if you want to enable InnoDB!
skip-innodb

[mysqldump]
quick
set-variable    = max_allowed_packet=1M

[mysql]
 #no-auto-rehash # faster start of mysql but no tab
completition

[isamchk]
set-variable    = key_buffer=16M

men ako pitash naprawi slednoto neshtO:
cp /etc/my.cnf /etc/my.cnf-

 safe_mysqld --user=mysql --err-log =
/var/log/mysql-dump.log&

tail -f /var/log/mysql-dump.log

i ot nqkude (next console) probwai mysql localhost -p
 posle switch na drugata consola i gledai kakwo dump-va
SQL-a
 P.s. btw ... puskal li si mysql_install_db? i po wajnoto s
kakuf user si go pusnal towa? 

Best Regards,
Danail Petrow

# listening on port 3306. The default is "disable" - for
security reasons.
skip-networking


comment skip-networking i stawa :>

 Mnogo vi blagodarq na vsichki, problema se reshi kato slojih
 komentar na skil-networking. Mnogo 10x. Sega ostava da
 razbera kak moga da dam dostup na opredeleno IP do mysql
servera, pri opit za connectvane rezultata beshe:

 C♦Host '172.16.0.2' is not allowed to connect to this
MySQL server

Connection to host lost.

 Shte se radvam ako nqkoi spodeli kak stava, dali ot
configuracionniqt fail my.cnf ili ot mysqlroot i t.n.!!!

Hi,
 Neka priemem che imash mreja 10.0.0.0/24 i remote mrejata ot
koqto iskash da se connect-nesh 192.168.0.0/24
Wischko koeto trqbwa da naprawish e slednoto:
mysql -p

use mysql;
 update user set Host='192.168.0.%' WHERE Host='localhost'
and User='root';

mislq che towa shte swurshi rabota :!)

BR,
Danail Petrow

Hi,
 Neka priemem che imash mreja 10.0.0.0/24 i remote mrejata ot
koqto iskash da se connect-nesh 192.168.0.0/24
Wischko koeto trqbwa da naprawish e slednoto:
mysql -p

use mysql;
 update user set Host='192.168.0.%' WHERE Host='localhost'
and User='root';
FLUSH PRIVILEGES;

 Ako iskash mojesh da poglednesh documentaciata na
 www.mysql.org , tam naistina ima wsichko koeto ti trqbwa da
znaesh za mysql :)))
http://www.mysql.com/doc/en/Adding_users.html

mislq che towa shte swurshi rabota :!)

BR,
Danail Petrow

Hi,
 Neka priemem che imash mreja 10.0.0.0/24 i remote mrejata ot
koqto iskash da se connect-nesh 192.168.0.0/24
Wischko koeto trqbwa da naprawish e slednoto:
mysql -p

use mysql;
 update user set Host='192.168.0.%' WHERE Host='localhost'
and User='root';
FLUSH PRIVILEGES;

 Ako iskash mojesh da poglednesh documentaciata na
 www.mysql.org , tam naistina ima wsichko koeto ti trqbwa da
znaesh za mysql :)))
http://www.mysql.com/doc/en/Adding_users.html

mislq che towa shte swurshi rabota :!)

BR,
Danail Petrow

Hi,
 Neka priemem che imash mreja 10.0.0.0/24 i remote mrejata ot
koqto iskash da se connect-nesh 192.168.0.0/24
Wischko koeto trqbwa da naprawish e slednoto:
mysql -p

use mysql;
 update user set Host='192.168.0.%' WHERE Host='localhost'
and User='root';
FLUSH PRIVILEGES;

 Ako iskash mojesh da poglednesh documentaciata na
 www.mysql.org , tam naistina ima wsichko koeto ti trqbwa da
znaesh za mysql :)))
http://www.mysql.com/doc/en/Adding_users.html

mislq che towa shte swurshi rabota :!)

BR,
Danail Petrow

Mnogo blagodarq!