mysql via ip adress

[Repute]

How can I manage to connect to mysql via my servers ip adress?
I set mysql via network to off wit the lampp security promt...

Thnx for helping me out!

Greets,

Repute

[Wiedmann]

my.cnf

Code: Select all

[mysqld]
port  = 3306

[Repute]

Hmmm did that but doesn't work.
I try to connect to my database from my workstation with the following program but it says that it can't connect I have also some virtual host in http and also a host to mydomainname:3306

Thnx for helping me out!

[Wiedmann]

with the following program but it says that it can't connect

- Which program?
- Complete error message?

I have also some virtual host in http and also a host to mydomainname:3306

You have a vhost in Apache that listen on port 3306? That's not really a good idea... because this is the standard port for MySQL. One of these two ports you must change.

[Repute]

Thnx for helping me!

I want to use http://www.mariovaldez.net/software/oscpmwin for oscommerce

Vhost in apach is that the same as in http.conf?
That's not really a good idea... because this is the standard port for MySQL.
Can I choos any port? Wahta do yuou mean exactly?

Sorry if I'am asking dumb things hehe...

Thnx!

[Repute]

Someone?

[Repute]

Please help me I'm desparate!

[ascheinberg]

Please help me I'm desparate!

I ran the security tool for XAMPP, and later wanted to access MySQL via the network.

Wiedmann's fix DOES work. Open your my.cnf file, change the port=0 to port=3306, then visit the terminal and type

#/opt/lampp/lampp restart

that does work. If you set up virtal hosts, especially if one is served on 3306 (which seems like a very bad idea), you're on your own.