Ubuntu 22.04 with mysql-server 8.0.32-0ubuntu0.22.04.2
mysql wouldn't start with error
sudo systemctl status mysql.service
# output
Error: 99 (Cannot assign requested address)
Cause
I was using Docker on this host and had added the the Docker network host IP Address to mysqld.cnf
to allow connection from Docker containers and after removing Docker 172.17.0.1
was no longer a valid address
My /etc/mysql/mysql.conf.d/mysqld.cnf
had the following in it
bind-address = 127.0.0.1,172.17.0.1
mysqlx-bind-address = 127.0.0.1,172.17.0.1
Fix
bind-address = 127.0.0.1
mysqlx-bind-address = 127.0.0.1
Restart mysqld
sudo systemctl start mysql.service
0 Comments