mysql via ip adress

Problems with the Linux version of XAMPP, questions, comments, and anything related.

mysql via ip adress

Postby Repute » 13. January 2005 21:19

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
"Keep your face in the sunshine so the shadows fall behind you!"

Repute | http://www.repute.nl
User avatar
Repute
 
Posts: 52
Joined: 12. January 2003 14:33

Postby Wiedmann » 13. January 2005 23:13

my.cnf
Code: Select all
[mysqld]
port  = 3306
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Repute » 15. January 2005 16:06

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!
"Keep your face in the sunshine so the shadows fall behind you!"

Repute | http://www.repute.nl
User avatar
Repute
 
Posts: 52
Joined: 12. January 2003 14:33

Postby Wiedmann » 15. January 2005 17:06

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Repute » 15. January 2005 17:39

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!
"Keep your face in the sunshine so the shadows fall behind you!"

Repute | http://www.repute.nl
User avatar
Repute
 
Posts: 52
Joined: 12. January 2003 14:33

Postby Repute » 16. January 2005 12:23

Someone?
"Keep your face in the sunshine so the shadows fall behind you!"

Repute | http://www.repute.nl
User avatar
Repute
 
Posts: 52
Joined: 12. January 2003 14:33

Postby Repute » 17. January 2005 21:52

Please help me I'm desparate!
"Keep your face in the sunshine so the shadows fall behind you!"

Repute | http://www.repute.nl
User avatar
Repute
 
Posts: 52
Joined: 12. January 2003 14:33

It does work

Postby ascheinberg » 27. January 2005 03:42

Repute wrote: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.
ascheinberg
 
Posts: 17
Joined: 05. August 2004 16:20
Location: Orlando, FL


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 12 guests