Honeypots
Re: remote mysql login Jul 12 2006 08:59AM
davidhawksuk yahoo co uk
Hi thanks for all your help I have sucessfully connected.

If anyone would like to know how here is what I have done.

1. edit file /etc/hflowd/my.cnf to be as follows:

#bin-log

skip-name-resolve

datadir=/var/lib/mysql

set-variable=key_buffer_size=256M

set-variable=table_cache=256

set-variable=snort_buffer=128M

bind-address = 192.168.1.104

[mysql.server]

user=mysql

basedir=/var/lib

[safe_mysqld]

err-log=/var/log/mysqld.log

pid-file=/var/run/mysql/mysqld.pid

Essentially removing these two lines

skip-networking

socket=/var/lib/mysql/mysql.sock

and adding:

bind-address = 192.168.1.104

Where 192.168.1.104 is IP of themanagement inteface

2. Connected remotely using the deafault account

Many thnaks for your help especially rob for showing me the lines to change ;)

/ David

[ reply ]


 

Privacy Statement
Copyright 2010, SecurityFocus