Page 1 of 1

mysql network problem

PostPosted: 09. February 2009 19:21
by dagamerc13
hi i went into the secure lampp and when it said to make mysql not accessible from the network i said yes. well now i need it to be accessible through the network. how do i set it back because when i re run the security part of lampp it skips the mysql part? any help is appreciated =)

Re: mysql network problem

PostPosted: 20. February 2009 11:57
by dmphotography
Hey dagamerc13,

Open your /opt/lampp/etc/my.cnf file. You can use this command to do so and have proper editing permissions:
Code: Select all
sudo gedit /opt/lampp/etc/my.cnf


Now find the following and comment it out as shown here:

Code: Select all
skip-networking

Change it to:

#skip-networking


Now type this to restart everything:

Code: Select all
sudo /opt/lampp/lampp restart


That should change it back to the default.