Score:0

Help me to fix mysql server installation problem!

cn flag

I am trying to install MySQL Server, but the installation failed due to an error. I would like to remove it, but i get a message like this:

Test

What should i do to solve the problem?

Error.log

2022-01-25T10:40:05.299282Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-25T10:40:05.300660Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-25T10:40:05.300729Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-25T10:40:05.324749Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-01-25T10:40:05.409928Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2022-01-25T10:40:05.410874Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060
2022-01-25T10:40:06.840202Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
2022-01-25T10:42:08.069525Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 12205
2022-01-25T10:42:08.089132Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-25T10:42:08.824374Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-25T10:42:09.040556Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2022-01-25T10:42:09.040636Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2022-01-25T10:42:09.299982Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-25T10:42:09.300036Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-25T10:42:09.301542Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-25T10:42:09.301625Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-25T10:42:09.325544Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-01-25T10:42:09.351725Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.27-0ubuntu0.20.04.1'  socket: '/tmp/tmp.KohPAioZGD/mysqld.sock'  port: 0  (Ubuntu).
2022-01-25T10:42:09.386820Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2022-01-25T10:42:10.837554Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
2022-01-25T10:42:11.995751Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 12274
2022-01-25T10:42:12.005369Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-25T10:42:12.747685Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-25T10:42:12.933364Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2022-01-25T10:42:13.181438Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-25T10:42:13.181487Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-25T10:42:13.182768Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-25T10:42:13.182831Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-25T10:42:13.206950Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-01-25T10:42:13.282667Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2022-01-25T10:42:13.284156Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060
2022-01-25T10:42:14.754694Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
2022-01-25T10:42:32.865542Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 12536
2022-01-25T10:42:33.007656Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-25T10:42:34.147047Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-25T10:42:34.390266Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2022-01-25T10:42:34.390315Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2022-01-25T10:42:34.659271Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-25T10:42:34.659344Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-25T10:42:34.660751Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-25T10:42:34.660816Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-25T10:42:34.718062Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-01-25T10:42:34.749163Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.27-0ubuntu0.20.04.1'  socket: '/tmp/tmp.kSCOqbDXGx/mysqld.sock'  port: 0  (Ubuntu).
2022-01-25T10:42:34.925055Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2022-01-25T10:42:36.212460Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
2022-01-25T10:42:37.555335Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 12606
2022-01-25T10:42:37.575923Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-25T10:42:38.345254Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-25T10:42:38.519140Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2022-01-25T10:42:38.773451Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-25T10:42:38.773504Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-25T10:42:38.774897Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-25T10:42:38.774964Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-25T10:42:38.800257Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-01-25T10:42:38.884276Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2022-01-25T10:42:38.885230Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060
2022-01-25T10:42:40.327843Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
2022-01-25T10:45:51.630344Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 13841
2022-01-25T10:45:51.646700Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-25T10:45:52.438652Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-25T10:45:52.613108Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2022-01-25T10:45:52.613170Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2022-01-25T10:45:52.873434Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-25T10:45:52.873488Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-25T10:45:52.874866Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-25T10:45:52.874932Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-25T10:45:52.907239Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-01-25T10:45:52.935093Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.27-0ubuntu0.20.04.1'  socket: '/tmp/tmp.HOuAtvkigM/mysqld.sock'  port: 0  (Ubuntu).
2022-01-25T10:45:52.971307Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2022-01-25T10:45:54.415072Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
2022-01-25T10:45:55.583293Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 13911
2022-01-25T10:45:55.592687Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-25T10:45:56.320365Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-25T10:45:56.511345Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2022-01-25T10:45:56.746939Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-25T10:45:56.746992Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-25T10:45:56.748386Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-25T10:45:56.748452Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-25T10:45:56.780742Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-01-25T10:45:56.831204Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2022-01-25T10:45:56.832723Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060
2022-01-25T10:45:58.298319Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
2022-01-25T10:46:30.285819Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 14235
2022-01-25T10:46:30.302982Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-25T10:46:31.072410Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-25T10:46:31.251606Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2022-01-25T10:46:31.251666Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2022-01-25T10:46:31.512093Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-25T10:46:31.512148Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-25T10:46:31.513579Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-25T10:46:31.513649Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-25T10:46:31.537627Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-01-25T10:46:31.558367Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.27-0ubuntu0.20.04.1'  socket: '/tmp/tmp.qtRG0LL0JW/mysqld.sock'  port: 0  (Ubuntu).
2022-01-25T10:46:31.592192Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2022-01-25T10:46:33.080161Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
2022-01-25T10:46:34.208065Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 14304
2022-01-25T10:46:34.315059Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-25T10:46:35.212329Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-25T10:46:35.379763Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2022-01-25T10:46:35.618514Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-25T10:46:35.618574Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-25T10:46:35.619846Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-25T10:46:35.619915Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-25T10:46:35.643917Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-01-25T10:46:35.719457Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2022-01-25T10:46:35.720914Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060
2022-01-25T10:46:37.201689Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
in flag
The version of MySQL you are installing is not the standard package offered by the default repositories. Is there something in particular that the alternate version offers that you need? Either way, a little more information will be required. Could you [edit] your question to include some of the recent errors recorded in `/var/log/mysql/error.log`? This should explain why the software is not running, then we can get it fixed so that you can either use it or remove it
Marc Vanhoomissen avatar
in flag
Does this answer your question? [Error installing MySQL](https://askubuntu.com/questions/1257643/error-installing-mysql)
mangohost

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.