Hallo, I use XAMPP 7.0.3-0 on Lubuntu.
I have once disabled the mysql access via network with the command:
sudo /opt/lampp/lampp security
But later I had to reset this as I need it for the virtualbox guest system via Host Only Adapter: I did this in the my.cnf in /opt/lampp/etc/) and commented the line: skip-networking
according to this:
https://community.apachefriends.org/f/viewtopic.php?p=96598
I even restarted the computer but still I get an error in my webstite:
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /opt/lampp/htdocs/sites/....
this error comes only when I access the website with an IP address but NOT via “localhost” !
(I need IP address for the guest system in vbox)
When I do /opt/lampp/lampp security again I see :
MySQL is accessable via network.
(so, the change in the my.cnf file had effect) but I get also in the Terminal:
MySQL has a root passwort set. Fine!
Really fine! But I never have set this password myself.
This password should be the reason for the error on my website.
Where is is password and how to change it ???
But strange for me is in phpmyadmin which is working I get the typical default message:
You are connected as 'root' with no password, … ?????