首页 > 解决方案 > 错误:设置 GCP MySQL 服务器时出错

问题描述

这是我可以复制的步骤:

计算引擎创建:

1.select F1-Micro instance.
2.Select Ubuntu 20.04 LTS Minimal.

安装:

$sudo apt-get update
$sudo apt-get install mysql-server

我的问题是如何在 GCP 中设置 MySQL 服务器时不会出错?

这是错误:

     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: activating (start-pre) since Fri 2021-01-29 20:58:52 UTC; 3s ago
Cntrl PID: 2338 (mysql-systemd-s)
      Tasks: 1 (limit: 682)
     Memory: 1.7M
     CGroup: /system.slice/mysql.service
             ├─2338 /bin/bash /usr/share/mysql/mysql-systemd-start pre
             ├─2356 /bin/bash /usr/share/mysql/mysql-systemd-start pre
             ├─2357 /bin/bash /usr/share/mysql/mysql-systemd-start pre
             ├─2358 [my_print_defaul]
             ├─2359 sed -n s/^--datadir=//p
             └─2360 tail -n 1
Jan 29 20:58:49 instance-1 systemd[1]: mysql.service: Killing process 2233 (mysqld) with signal SIGKILL.
Jan 29 20:58:51 instance-1 systemd[1]: mysql.service: Main process exited, code=killed, status=9/KILL
Jan 29 20:58:51 instance-1 systemd[1]: mysql.service: Failed with result 'timeout'.
Jan 29 20:58:51 instance-1 systemd[1]: Failed to start MySQL Community Server.
Jan 29 20:58:52 instance-1 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 1.
Jan 29 20:58:52 instance-1 systemd[1]: Stopped MySQL Community Server.
Jan 29 20:58:52 instance-1 systemd[1]: Starting 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
Setting up libcgi-pm-perl (4.46-1) ...
Setting up libhtml-template-perl (2.97-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
Setting up libcgi-fast-perl (1:2.15-1) ...
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Processin
g triggers for systemd (245.4-4ubuntu3.4) ...
Processing triggers for libc-bin (2.31-0ubuntu9.1) ...
Errors were encountered while processing:
 mysql-server-8.0
 mysql-server```

标签: mysqlgoogle-cloud-platform

解决方案


推荐阅读