New install: localhost bind-address
Posted by: Chris Cant
Date: March 15, 2023 01:55PM

I'm just setting a new server on Ubuntu 22.04 and have installed the standard package 8.0.32-0ubuntu0.22.04.2

I'd like to suggest that /etc/mysql/mysql.conf.d/mysqld.cnf
has this line by default:
bind-address = 127.0.0.1
replaced with:
bind-address = 127.0.0.1,::1
so as to bind to localhost on IPv6 as well as IPv4. As localhost by default connected to IPv6, mysql was not responding before the change.

This caught me out of a bit when trying to run a nodejs application and run monit. I also changed the follow line (mysqlx-bind-address) similarly. And I also had to uncomment the "pid-file" line to get monit to work.

Thanks, Chris

Options: ReplyQuote


Subject
Written By
Posted
New install: localhost bind-address
March 15, 2023 01:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.