Join Log in
Score:0
Parry avatar Ubuntu

MySQL Server fails to start while remotely accessing server through PuTTy

cn flag
Parry

I am accessing a remote Ubuntu server via PuTTy and have installed MySQL server on it using sudo apt-get install mysql-server

After that I am trying to start the MySQL server so that I can connect using MySQL Workbench. To start MySQL, I am using sudo /etc/init.d/mysql start

But I get an error message Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because a fatal signal was delivered to the control process. See "systemctl status mysql.service" and "journalctl -xe" for details.

The systemctl status mysql.service is as below

 mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset:>
     Active: activating (start) since Mon 2021-07-05 10:58:13 UTC; 566ms ago
    Process: 70915 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=>
   Main PID: 70923 (mysqld)
     Status: "Server startup in progress"
      Tasks: 1 (limit: 1040)
     Memory: 59.9M
     CGroup: /system.slice/mysql.service
             └─70923 /usr/sbin/mysqld

Jul 05 10:58:13 mopic systemd[1]: mysql.service: Main process exited, code=kill>
Jul 05 10:58:13 mopic systemd[1]: mysql.service: Failed with result 'signal'.
Jul 05 10:58:13 mopic systemd[1]: Failed to start MySQL Community Server.
Jul 05 10:58:13 mopic systemd[1]: mysql.service: Scheduled restart job, restart>
Jul 05 10:58:13 mopic systemd[1]: Stopped MySQL Community Server.
Jul 05 10:58:13 mopic systemd[1]: Starting MySQL Community Server...

journalctl -xe gives the following result.

 Support: http://www.ubuntu.com/support
░░
░░ A start job for unit mysql.service has finished with a failure.
░░
░░ The job identifier is 26922 and the job result is failed.
Jul 05 10:59:49 mopic xrdp[71392]: (71392)(140122693663616)[DEBUG] Closed socke>
Jul 05 10:59:49 mopic gnome-shell[71261]: GNOME Shell started at Mon Jul 05 202>
Jul 05 10:59:49 mopic gnome-shell[71261]: JS ERROR: TypeError: method Gio.File.>
                                          _handleLockScreenWarning@resource:///>
                                          _initializeUI/<@resource:///org/gnome>
                                          _startupAnimationComplete@resource://>
                                          onComplete@resource:///org/gnome/shel>
                                          _makeEaseCallback/<@resource:///org/g>
                                          _easeActor/<@resource:///org/gnome/sh>
Jul 05 10:59:49 mopic gnome-shell[71261]: Registering session with GDM
Jul 05 10:59:49 mopic gnome-shell[71261]: cr_parser_new_from_buf: assertion 'a_>
Jul 05 10:59:49 mopic gnome-shell[71261]: cr_declaration_parse_list_from_buf: a>
Jul 05 10:59:50 mopic sshd[71341]: Received disconnect from 182.61.18.141 port >
Jul 05 10:59:50 mopic sshd[71341]: Disconnected from invalid user lab 182.61.18>
Jul 05 10:59:50 mopic sshd[71314]: Received disconnect from 119.45.243.232 port>
Jul 05 10:59:50 mopic sshd[71314]: Disconnected from authenticating user root 1>
Jul 05 10:59:50 mopic gnome-shell[71261]: cr_parser_new_from_buf: assertion 'a_>
Jul 05 10:59:50 mopic gnome-shell[71261]: cr_declaration_parse_list_from_buf: a>

How to start MySQL server to connect from MySQL Workbench?

Contents of /var/log/mysql/error.log are as below

2021-07-05T10:27:16.439918Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 69180
2021-07-05T10:27:16.673531Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:27:18.883988Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 69226
2021-07-05T10:27:20.371299Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:27:41.760432Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 69327
2021-07-05T10:27:41.954025Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:49:55.965423Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 69828
2021-07-05T10:49:56.148128Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:49:58.542917Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 69874
2021-07-05T10:50:01.972484Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:50:48.383853Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 69979
2021-07-05T10:50:48.543834Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:50:50.658441Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70018
2021-07-05T10:50:52.030627Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:51:30.921701Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70121
2021-07-05T10:51:31.062285Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:51:33.891182Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70160
2021-07-05T10:51:56.466161Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:52:16.795594Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70271
2021-07-05T10:52:16.929850Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:52:20.054643Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70310
2021-07-05T10:52:22.260497Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:52:50.818967Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70419
2021-07-05T10:52:50.970639Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:56:43.861280Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70544
2021-07-05T10:56:43.997145Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:56:47.133985Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70589
2021-07-05T10:56:49.070259Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:57:17.953250Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70686
2021-07-05T10:57:18.138104Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:57:21.842623Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70725
2021-07-05T10:57:24.203111Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:57:49.465216Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70826
2021-07-05T10:57:49.640058Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:57:51.909627Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70865
2021-07-05T10:57:53.945342Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:58:23.005916Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 70985
2021-07-05T10:58:23.148879Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:58:26.639651Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 71028
2021-07-05T10:58:34.335098Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:58:51.658559Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 71120
2021-07-05T10:58:51.844002Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:58:55.083324Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 71161
2021-07-05T10:58:58.841832Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:59:18.637050Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 71257
2021-07-05T10:59:18.759465Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T10:59:21.616672Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 71296
2021-07-05T10:59:22.551136Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T11:04:43.993775Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 71483
2021-07-05T11:04:44.053546Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root
2021-07-05T11:04:44.316410Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-05T11:04:47.060536Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.21.04.1) starting as process 71528
2021-07-05T11:04:47.261956Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root
2021-07-05T11:04:50.273428Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
50
0 + 2
Marc Vanhoomissen avatar
in flag
Marc Vanhoomissen
Could you post the contents of `/var/log/mysql/error.log`?
0
Reply
Parry avatar
cn flag
Parry
Added the contents of /var/log/mysql/error.log to the question.
0
Reply
ธงชาติไทย
Elon Musk
I sit in a Tesla and translated this thread with Ai:

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.