MySQL Connect

6 views
Skip to first unread message

Volker A Mönch

unread,
Sep 4, 2011, 5:06:33 AM9/4/11
to OXID e-Shop Virtual Machine
Is it possible to connect the MySQL-Server from outside the VM. I have
tried it with "HeidiSQL", but without success. Any hints?

Viele Grüße,
Volker

Stöhr, Florian

unread,
Sep 4, 2011, 8:08:05 AM9/4/11
to oxi...@googlegroups.com, vmo...@googlemail.com
Hi,

by default: No, the mysqld listens on the local host socket only
(which is the default setup of mysqld).
But you may change the configuration, open a root shell via the
frontend and type

mcedit /etc/mysql/my.cnf

now locate the line "bind-address" (line 47) and change the value
"127.0.0.1" to "0.0.0.0". save (key F2)
and quit the editor.

run:

/etc/initd./mysql restart

mysqld should listen on every network address now, so you may connect
to the server with your
frontend.

-Flo

2011/9/4 Volker A Mönch <vmo...@googlemail.com>:

Volker A Mönch

unread,
Sep 4, 2011, 1:29:04 PM9/4/11
to oxi...@googlegroups.com
Hi, 

thank you so much for the quick response and the detailed explanation! The name of my machine is still not allowed, but I think, now I can help by myself... 

Noch ein schönes Restwochenende 
Volker 
--

TimeLine® eBusiness
 GmbH & Co. KG
Software & Service
Ein Unternehmen der TimeLine®-Business-Solutions-Group

Telefon: 02051 92 55 66
Mobil: 0172 86 25 166
Web: 925566.de
Web: timeline-ebusiness.com timeline-neo.de
Google+: https://plus.google.com/posts


________________________________________________________________
erforderliche Angaben gemäß § 37a HGB, § 35a GmbHG:
Amtsgericht Velbert   HRA 1615
Geschäftsführer: Volker A Mönch | Boris Gebauer

¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

Reply all
Reply to author
Forward
0 new messages