Re: remote mysql login

From: <davidhawksuk_at_yahoo.co.uk>
Date: 12 Jul 2006 08:59:11 -0000

('binary' encoding is not supported, stored as-is) 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
Received on Jul 12 2006