Apache Friends Support Forum

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

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

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