Arch Linux

denizozturk

Member

Registered: 2022-06-13

Posts: 1

Failed to start MySQL Server (ERROR 2002 (HY000))

I installed the MySQL service before and was using it without any problems. After installing VirtualBox yesterday, I noticed that this service is not running.

I tried to get the service to run again but I couldn't, so even though I uninstalled and reinstalled it many times, I got the same error every time.

When I want to start the MySQL service

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

Status:

× mysqld.service - MySQL Server
     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Mon 2022-06-13 10:18:41 +03; 1min 7s ago
       Docs: man:mysqld(8)
             http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 2675 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Process: 2696 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
   Main PID: 2696 (code=exited, status=1/FAILURE)
     Status: "Data Dictionary upgrade from MySQL 5.7 in progress"
      Error: 22 (Invalid argument)
        CPU: 237ms

Jun 13 10:18:41 ozturk mysqld[2696]: 2022-06-13T07:18:41.043609Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are>
Jun 13 10:18:41 ozturk mysqld[2696]: 2022-06-13T07:18:41.043638Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page>
Jun 13 10:18:41 ozturk mysqld[2696]: 2022-06-13T07:18:41.043751Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initializatio>
Jun 13 10:18:41 ozturk mysqld[2696]: 2022-06-13T07:18:41.544731Z 1 [ERROR] [MY-011013] [Server] Failed to initialize>
Jun 13 10:18:41 ozturk mysqld[2696]: 2022-06-13T07:18:41.545359Z 0 [ERROR] [MY-010020] [Server] Data Dictionary init>
Jun 13 10:18:41 ozturk mysqld[2696]: 2022-06-13T07:18:41.546329Z 0 [ERROR] [MY-010119] [Server] Aborting
Jun 13 10:18:41 ozturk mysqld[2696]: 2022-06-13T07:18:41.547059Z 0 [System] [MY-010910] [Server] /usr/bin/mysqld: Sh>
Jun 13 10:18:41 ozturk systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Jun 13 10:18:41 ozturk systemd[1]: mysqld.service: Failed with result 'exit-code'.
Jun 13 10:18:41 ozturk systemd[1]: Failed to start MySQL Server.

After reinstalling the MySQL service, I did not complete the installation steps because it gives an error.

Error: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

Package is not including mysqld.sock (/run/mysqld/mysqld.sock) which does not allows to complete the mysql_secure_installation command. Am I doing something wrong or is it a package error?

Last edited by denizozturk (2022-06-13 07:28:17)

V1del

Forum Moderator

Registered: 2012-10-16

Posts: 21,724

Re: Failed to start MySQL Server (ERROR 2002 (HY000))

please actually mention what lead to the solution and edit the thread title to mark as [SOLVED] yourself: https://wiki.archlinux.org/title/Genera … way_street