Security Script MySQL Network Setting Question

[dorn]

Upon running the security script (/opt/lampp/lampp security) a setting appears asking the following:

MySQL is accessible via network. Normally Thats's not reccomended. Do you want me to turn it off? [yes]

I have a few of questions regarding this option.

1. What exactlty is this securing?

2. Is XAMPP limited in any way by turning this off? Such as setting up databases.

3. Can this setting be turned back on if turned off in the security setup?

Thanks for any reples.

[Wiedmann]

1. What exactlty is this securing?

Access throught TCP/IP.

2. Is XAMPP limited in any way by turning this off?

Yes, you can't access the MySQL server throught a network.

3. Can this setting be turned back on if turned off in the security setup?

Sure, it can (It's a setting in the file "my.cnf").

[dorn]

Thanks for the reply.

I looked over the my.cnf file found in /opt/lampp/etc/

Heres how I'm going about turning on/off networking.


OFF

Code: Select all

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

ON

Code: Select all

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

I'm assuming thats the correct code to comment/uncomment.

Would there happen to be a command to add remove these comments rather than editing the file?

[xnemesis]

run ./lampp security (I think that's the command) ./lampp will provide a list though.