Make Mysql listening to all ports Ubuntu 22.04

ilie alexandru

6/12/24, 1:32 PM

I have this code:

[mysqld]

bind-address = 0.0.0.0
default-storage-engine = innodb
innodb file per table
collation-server = utf8 general ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

This is for an older version of Ubuntu, now I am using Ubuntu 22.04 and I am trying to make it work. I am trying to put it in the "/etc/mysql/conf.d" directory, but I don't think that is the place in this version of Ubuntu.

I put the code and when I am trying to restart the service is throwing the error:

Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.

The error that the "systemctl status mysql.service" is giving is:

× mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Mon 2023-06-12 14:07:46 UTC; 6s ago
    Process: 19824 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
        CPU: 34ms

Jun 12 14:07:46 controller systemd[1]: Failed to start MySQL Community Server.
Jun 12 14:07:46 controller systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Jun 12 14:07:46 controller systemd[1]: Stopped MySQL Community Server.
Jun 12 14:07:46 controller systemd[1]: mysql.service: Start request repeated too quickly.
Jun 12 14:07:46 controller systemd[1]: mysql.service: Failed with result 'exit-code'.
Jun 12 14:07:46 controller systemd[1]: Failed to start MySQL Community Server.

Do you have any suggestion?

244

1 + 3

mysql

22.04

steeldriver

6/12/24, 2:05 PM

I think you probably mean *"all interfaces"* rather than *"all ports"*. Have you run the suggested commands `systemctl status mysql.service` and `journalctl -xeu mysql.service`? What additional information do they provide?

ilie alexandru

6/12/24, 2:06 PM

Yes I run both of them, give me 2 minutes to add those information also in question

waltinator

6/12/24, 4:17 PM

Did you install and set up `mysqld`, the MySQL server? Find a package to install with `apt-cache search mysqld`.

Score:0

Ubuntu

ilie alexandru

6/14/24, 1:42 PM

I found out what was the error, it was actually a typo error in the above code, instead of writing:

[mysqld]

bind-address = 0.0.0.0
default-storage-engine = innodb
innodb file per table
collation-server = utf8 general ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

I should have wrote:

[mysqld]

bind-address = 0.0.0.0
default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

+ 0

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Make Mysql listening to all ports Ubuntu 22.04

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.