MySQL doesn't start on Ubuntu 22.04; unknown variable 'mysqlx-bind-address=127.0.0.1'

SAAD 34

7/17/24, 2:16 AM

I'm facing an issue with installing MySQL server on Ubuntu 22.04. When I try to start the MySQL service using the command sudo service mysql start, I get the following error message

The error message suggests a configuration error in the server. Can you guide me through the correct steps to successfully start the MySQL server? Thank you." Knowing that I still haven't linked my hosting to my domain

● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: activating (auto-restart) (Result: exit-code) since Mon 2023-07-17 01:55:02 UTC; 9ms ago
    Process: 348248 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
        CPU: 82ms

Jul 17 01:55:02 server1.elhodhod.ma mysql-systemd-start[348248]: ERROR: Unable to start MySQL server:
Jul 17 01:55:02 server1.elhodhod.ma mysql-systemd-start[348248]: 2023-07-17  1:55:02 0 [ERROR] mysqld: unknown variable 'mysqlx-bind-address=127.0.0.1'
Jul 17 01:55:02 server1.elhodhod.ma mysql-systemd-start[348248]: Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.
Jul 17 01:55:02 server1.elhodhod.ma mysql-systemd-start[348248]: Once the problem is resolved, restart the service.
Jul 17 01:55:02 server1.elhodhod.ma systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Jul 17 01:55:02 server1.elhodhod.ma systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 17 01:55:02 server1.elhodhod.ma systemd[1]: Failed to start MySQL Community Server.
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.

Errors were encountered while processing:
 mysql-server-8.0
 mysql-server
needrestart is being skipped since dpkg has failed
E: Sub-process /usr/bin/dpkg returned an error code (1)

142

1 + 2

mysql

ubuntu

Jaromanda X

7/17/24, 5:48 AM

the variable is `mysqlx_bind_address` - the command line format is `--mysqlx-bind-address=127.0.0.1` - I suspect you've conflated the two

Wilson Hauck

8/25/24, 4:28 PM

Are you back on-line?

Score:1

Server

AlexD

7/17/24, 5:43 AM

You have a variable mysqlx-bind-address defined in your MySQL configuration files which your version of MySQL doesn't understand and this prevents it from starting. You need to remove this variable and review your configuration files so that it matches the version of MySQL you have installed.

+ 0

Elon Musk

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

EN: MySQL doesn't start on Ubuntu 22.04; unknown variable 'mysqlx-bind-address=127.0.0.1'

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.