Am Montag, 11. April 2005 21:44 schrieb Peter Wiersig: > On Mon, Apr 11, 2005 at 09:34:08PM +0200, Al Bogner wrote: > > Wie mache ich nur den MySQL-Port einfachst auf, also ohne > > FW-Builder, etc.? > > Laeuft denn eine Netfilter-Regelwerk?
Nachdem einige Ports offen und die meisten zu sind, denke ich, dass da per default schon was installiert ist. Als Debian-Neuling und Yast-Gew�hnter, muss ich da erst bei einigen Dingen durch :-) > Hoert der Mysql-Daemon ueberhaupt auf dem Port? Also phpmyadmin meint 3306. Ich k�nnte mein Problem auch so formulieren: mysql --host=192.168.1.100 --user=root --password= adressen ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.100' (111) mysql --host=localhost --user=root --password= adressen Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. /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 = /tmp language = /usr/share/mysql/english skip-external-locking old_passwords = 1 bind-address = 127.0.0.1 key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K query_cache_limit = 1048576 query_cache_size = 16777216 query_cache_type = 1 log-bin = /var/log/mysql/mysql-bin.log max_binlog_size = 104857600 [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 16M Al
