Scribd
Upload
4 views3 pages

MySQL 8.0.27 Server Initialization Logs

The log file documents the startup of a MySQL database server on an Ubuntu system. It records the initialization of the InnoDB storage engine, warnings about deprecated TLS versions enabled, and notes that the server is ready and listening for connections on port 3306 and socket /var/run/mysqld/mysqld.sock. The log also shows the server starting and shutting down multiple times in response to shutdown commands.

Uploaded by

Akula Mayaya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views3 pages

MySQL 8.0.27 Server Initialization Logs

The log file documents the startup of a MySQL database server on an Ubuntu system. It records the initialization of the InnoDB storage engine, warnings about deprecated TLS versions enabled, and notes that the server is ready and listening for connections on port 3306 and socket /var/run/mysqld/mysqld.sock. The log also shows the server starting and shutting down multiple times in response to shutdown commands.

Uploaded by

Akula Mayaya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

2021-12-20T09:32:20.

998258Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld


(mysqld 8.0.27-0ubuntu0.20.04.1) initializing of server in progress as process
2964
2021-12-20T09:32:21.007278Z 1 [System] [MY-013576] [InnoDB] InnoDB
initialization has started.
2021-12-20T09:32:21.722532Z 1 [System] [MY-013577] [InnoDB] InnoDB
initialization has ended.
2021-12-20T09:32:22.760572Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1 is enabled for channel mysql_main
2021-12-20T09:32:22.760612Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1.1 is enabled for channel mysql_main
2021-12-20T09:32:22.811584Z 6 [Warning] [MY-010453] [Server] root@localhost is
created with an empty password ! Please consider switching off the --
initialize-insecure option.
2021-12-20T09:32:24.017230Z 6 [System] [MY-013172] [Server] Received SHUTDOWN
from user boot. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2021-12-20T09:32:28.115554Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld
(mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 3014
2021-12-20T09:32:28.154275Z 1 [System] [MY-013576] [InnoDB] InnoDB
initialization has started.
2021-12-20T09:32:28.545990Z 1 [System] [MY-013577] [InnoDB] InnoDB
initialization has ended.
2021-12-20T09:32:28.683767Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx
reported: 'Preparation of I/O interfaces failed, X Protocol won't be
accessible'
2021-12-20T09:32:28.683809Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx
reported: 'Setup of socket: '/var/run/mysqld/[Link]' failed, can't create
lock file /var/run/mysqld/[Link]'
2021-12-20T09:32:28.829261Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1 is enabled for channel mysql_main
2021-12-20T09:32:28.829292Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1.1 is enabled for channel mysql_main
2021-12-20T09:32:28.832560Z 0 [Warning] [MY-010068] [Server] CA certificate
[Link] is self signed.
2021-12-20T09:32:28.832640Z 0 [System] [MY-013602] [Server] Channel mysql_main
configured to support TLS. Encrypted connections are now supported for this
channel.
2021-12-20T09:32:28.833705Z 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.
2021-12-20T09:32:28.856463Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld:
ready for connections. Version: '8.0.27-0ubuntu0.20.04.1' socket:
'/tmp/tmp.jnmIylEhj0/[Link]' port: 0 (Ubuntu).
2021-12-20T09:32:28.922554Z 0 [System] [MY-013172] [Server] Received SHUTDOWN
from user <via user signal>. Shutting down mysqld (Version: 8.0.27-
0ubuntu0.20.04.1).
2021-12-20T09:32:30.367156Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld:
Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-20T09:32:31.645839Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld
(mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 3082
2021-12-20T09:32:31.658985Z 1 [System] [MY-013576] [InnoDB] InnoDB
initialization has started.
2021-12-20T09:32:31.957325Z 1 [System] [MY-013577] [InnoDB] InnoDB
initialization has ended.
2021-12-20T09:32:32.080394Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx
reported: 'Setup of socket: '/var/run/mysqld/[Link]' failed, can't create
lock file /var/run/mysqld/[Link]'
2021-12-20T09:32:32.157397Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1 is enabled for channel mysql_main
2021-12-20T09:32:32.157422Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1.1 is enabled for channel mysql_main
2021-12-20T09:32:32.158336Z 0 [Warning] [MY-010068] [Server] CA certificate
[Link] is self signed.
2021-12-20T09:32:32.158378Z 0 [System] [MY-013602] [Server] Channel mysql_main
configured to support TLS. Encrypted connections are now supported for this
channel.
2021-12-20T09:32:32.159410Z 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.
2021-12-20T09:32:32.181063Z 7 [System] [MY-013172] [Server] Received SHUTDOWN
from user boot. Shutting down mysqld (Version: 8.0.27-0ubuntu0.20.04.1).
2021-12-20T09:32:32.181989Z 0 [System] [MY-011323] [Server] X Plugin ready for
connections. Bind-address: '[Link]' port: 33060
2021-12-20T09:32:33.602432Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld:
Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-20T09:32:35.227588Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld
(mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 3240
2021-12-20T09:32:35.240565Z 1 [System] [MY-013576] [InnoDB] InnoDB
initialization has started.
2021-12-20T09:32:35.592968Z 1 [System] [MY-013577] [InnoDB] InnoDB
initialization has ended.
2021-12-20T09:32:35.809399Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1 is enabled for channel mysql_main
2021-12-20T09:32:35.809422Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1.1 is enabled for channel mysql_main
2021-12-20T09:32:35.810506Z 0 [Warning] [MY-010068] [Server] CA certificate
[Link] is self signed.
2021-12-20T09:32:35.810544Z 0 [System] [MY-013602] [Server] Channel mysql_main
configured to support TLS. Encrypted connections are now supported for this
channel.
2021-12-20T09:32:35.830078Z 0 [System] [MY-011323] [Server] X Plugin ready for
connections. Bind-address: '[Link]' port: 33060, socket:
/var/run/mysqld/[Link]
2021-12-20T09:32:35.830321Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld:
ready for connections. Version: '8.0.27-0ubuntu0.20.04.1' socket:
'/var/run/mysqld/[Link]' port: 3306 (Ubuntu).
2021-12-20T11:42:19.587670Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld
(mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 613
2021-12-20T11:42:19.609354Z 1 [System] [MY-013576] [InnoDB] InnoDB
initialization has started.
2021-12-20T11:42:22.445269Z 1 [System] [MY-013577] [InnoDB] InnoDB
initialization has ended.
2021-12-20T11:42:22.667752Z 0 [System] [MY-010229] [Server] Starting XA crash
recovery...
2021-12-20T11:42:22.936018Z 0 [System] [MY-010232] [Server] XA crash recovery
finished.
2021-12-20T11:42:22.995568Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1 is enabled for channel mysql_main
2021-12-20T11:42:22.995596Z 0 [Warning] [MY-013746] [Server] A deprecated TLS
version TLSv1.1 is enabled for channel mysql_main
2021-12-20T11:42:22.998091Z 0 [Warning] [MY-010068] [Server] CA certificate
[Link] is self signed.
2021-12-20T11:42:22.998132Z 0 [System] [MY-013602] [Server] Channel mysql_main
configured to support TLS. Encrypted connections are now supported for this
channel.
2021-12-20T11:42:23.028732Z 0 [System] [MY-011323] [Server] X Plugin ready for
connections. Bind-address: '[Link]' port: 33060, socket:
/var/run/mysqld/[Link]
2021-12-20T11:42:23.028960Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld:
ready for connections. Version: '8.0.27-0ubuntu0.20.04.1' socket:
'/var/run/mysqld/[Link]' port: 3306 (Ubuntu).

You might also like