[Pitbull3]

Upgraded my web server to mysql 5.5 and now sourcebans won't connect.

L 08/08/2014 - 22:09:50: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '*********' (111). See FAQ: http://www.sourcebans.net/node/20

This link doesn't work: http://www.sourcebans.net/node/20



---- fixed, mysql 5.5 changes the way bind-address works for [mysqld] in /etc/my.cfg

changing it to bind-address=* allows all connections to connect to mysql with user/pass.....

[zeroibis]

Wait so how did you fix this?

Planning to update to 5.5 but need to know what needs to be fixed and how to do it.

[Pitbull3]

I am running cpanel... my own web server ect...

When you upgrade to mysql 5.5 they change a few things that aren't really covered... the only thing I had to change to fix remote mysql connections was this line under the [mysqld] section:

bind-address=127.0.0.1
to this
bind-address=*

In the file /etc/my.cnf

Essentially what the bind-address=127.0.0.1 was telling mysqld that the mysql server will only accept connections locally. So * means accept any connection with user/pass obviously.

[zeroibis]

Ah was it b/c they removed the "Remote Database Access Hosts" section in cpan with the latest version or do you just prefer to edit the file manually?

Also even though it is decrepit do mysql php functions still work?