Dotaz: Zend Studio 5

[pretender]

zdravim,

zkousim Zend Studio 5 a mam problem pripojit se pres neho na databazi MySQL(4.1.12,localhost). kdyz to zkousim vyhodim mi hlasku: "Server connection failure during transsaction. Due to underlying exception:'SocketException:ConnectExcepion:Connection refused'

Mysql mi nasloucha na socketu, jak udelat aby naslouchalo na TCP-portu 3306? (mandriva 2006) diky

Odpovědi

[Kyosuke]

Není v konfiguračním souboru MySQL řádek "skip-networking"? Pokud ano, MySQL nebinduje příslušný TCP port a používá jen Unix domain sockety.

[Kyosuke]

BTW, pojem "socket" se pojí i s TCP porty...

[pretender]

my.ndf
[mysqld]
datadir=/var/lib/mysql
#skip-networking
socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with old and
# shorter password hash.
# Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-------------------------
mysqladmin version vypise toto:
mysqladmin Ver 8.41 Distrib 4.1.12, for mandriva-linux-gnu on i586
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free
software, and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.12
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 8 sec

Threads: 1 Questions: 2 Slow queries: 0 Opens: 11 Flush tables: 1
Open tables: 0 Queries per second avg: 0.250

tak jsem asi ztracen..... :(

[Messa]

Zkuste přidat proměnnou port:

[mysqld]
datadir = /var/lib/mysql
port    = 3306
socket  = /var/lib/mysql/mysql.sock
...

[pretender]

taky nic... :(

[pretender]

Tak jo,nakonec jsem to vyresil, dik za pomoc. Problem byl v skip-networking
Prochazel jsem /rc.d/init.d/mysqld , v nem byl odkaz na config soubor v sysconfig/mysqld - no zde bylo zapnute skip-networking. diky.