MySQL security help

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

MySQL security help

Postby ascheinberg » 05. August 2004 16:40

I have been tasked with converting one of my MySQL databases in XAMPP over to SQL Server 2000. I have a tool to do this, but I can't connect to the MySQL server over the network since I ran ./lampp security. It doesn't work at all, even with the MySQL ODBC driver, or with MySQL Control Center or MySQL admin. I even tried to add an iptables rule to allow traffic on port 3306.

My question is, how can I allow network connections to MySQL again? Running the security program again doesn't help. I can't find any documentation to re-enable this access, and poking through /opt/lampp/etc/my.conf doesn't immediately show any way to do this. Anyone know how to reverse the security features?

Thanks!

Adam
ascheinberg
 
Posts: 17
Joined: 05. August 2004 16:20
Location: Orlando, FL

Postby Oswald » 05. August 2004 17:46

Dear Adam!

Looks like you disabled MySQL network access. ;)

Find the following lines in your /opt/lampp/etc/my.conf :

[mysqld]
# commented out by lampp security
#port = 3306
port = 0


and change them to

[mysqld]
port = 3306


Restart MySQL and you can access MySQL by network again.

Good luck
Oswald
User avatar
Oswald
Apache Friends
 
Posts: 2718
Joined: 26. December 2002 19:51
Location: Berlin, Germany
XAMPP Version: 5.5.19
Operating System: Linux

Awesome

Postby ascheinberg » 05. August 2004 18:13

I had already un-commented the #port = 3306 but didn't get rid of the port = 0 right after it. Thanks.

If you didn't get my e-mail last week, I wanted to say thanks again. XAMPP is simply amazing!

Also, I'd love to see PostgreSQL support in a future version. Awesome job!

Adam
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 4 guests