Re: MySQL-Port aufmachen
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
Reply to: