Topic: (Solved) Can not connect to mysql on lan

[origon]

I am trying to install phpbb 3.1.9 on my SME server, but when it come to the database i keep getting this error message
"Can't connect to MySQL server on '192.168.1.100' (111)"
I have used this command from mysql how to here on the how to link
"config setprop mysqld LocalNetworkingOnly no
expand-template /etc/my.cnf
sv t /service/mysqld"
but still i can't get in

[guest22]

Hi and welcome!

What is the exact error message(s) and what do the log file tell you please?

[origon]

The error message i get is from the phpbb install screen and it say

Can't connect to MySQL server on '192.168.1.100' (111)

my error log do not say anything about it.

[Jean-Philippe Pialasse]

Are you trying to connect to mysql from inside the same SME server with the mysql service or from a remote machine on the LAN?

- if yes, then you should use localhost or 127.0.0.1

- if from a machine on the lan, then you have to activate access to lan, search mysql in the wiki for procedure.

alternatively, if you are trying to reach a mysql instance on a remote machine not running sme, then you need to ooen the mysql port on the firewall of this machine an allow myql to listen on the lan. See ad hoc documentations.

[origon]

It is my desktop computer, and it is installed now, i just had to use localhost insted of ip.

Thanks for the help

[guest22]

It is my desktop computer, and it is installed now, i just had to use localhost insted of ip.

Thanks for the help

Good. Can you please add [SOLVED] to the subject of the original post please?