Dotaz: MySQL 5.6 pripojeni zvenci

[MichealG]

Ahoj kolegove,

mam trosku problem s Mysql 5.6. Nechce mi dovolit pripojeni zvenci a tim padem nemuzu pustit replikaci. Hledam vsude, ale nedari se mi to pustit. Je to Ubuntu 14.04.1

Tady je /etc/mysql/my.cnf

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /var/mysqltmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

#bind-address           = all
#0.0.0.0

key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8

myisam-recover         = BACKUP
max_connections        = 100
table_cache            = 64
thread_concurrency     = 10

query_cache_limit       = 16M
query_cache_size        = 16M
join_buffer_size        = 8M
tmp_table_size          = 64M
max_heap_table_size     = 64M

log_error = /var/log/mysql/error.log

server-id               = 7946917
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
#binlog_do_db           = include_database_name
binlog_ignore_db        = mysql
binlog_ignore_db        = phpmyadmin


[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

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

[isamchk]
key_buffer              = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

netstat -ln | grep mysql udela toto:

unix  2      [ ACC ]     STREAM     LISTENING     71538    /var/run/mysqld/mysqld.sock

Odpovědi

[Ivan Nový]

Nainstalujte si ispconfig a tam si nadefinujte uživatele a databázi a můžete ji pak povolit do remote režimu

[Filip Jirsák]

Podle netstatu server naslouchá jen na Unixovém socketu, ne na TCP. Předpokládám, že v bind-address musí být uvedeno, na jaké adrese (adresách) má server naslouchat.

[RadekM]

Ahoj,

staci zakomentovat v my.cnf jeste toto: skip-external-locking zmenit na: #skip-external-locking

nasledne restartovat mysql a menlo byt to jiz dle netstat naslouchat i na network rozhrani.

[MichealG]

ISPconfig by mi nepomohl, mel jsem tam webmin.

v bind-address jsem nechtel mit jen externi IP, protoze potrebuju taky pripojeni pres localhost.

Nakonec jsem to vyresil oklikou - nahodil jsem na ten server nove MySQL z mysql repozitare, ktere funguje skvele.

Diky vsem za pomoc!

[Filip Jirsák]

Když dáte do bind-address hodnotu all, bude server naslouchat na všech adresách.