在部署mysql容器时,发现3306端口被占用,但是却找不到具体的占用端口的进程,最后发现是服务器中MariaDB 数据库服务已经在运行,并持续监听3306端口,我把服务停掉就好了。

输入命令:查看mariadb服务状态

sudo systemctl status mariadb

获得结果:发现mariadb服务正在运行

● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Sat 2024-08-10 14:08:08 CST; 1h 21min ago
  Process: 973 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 881 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 972 (mysqld_safe)
    Tasks: 20
   Memory: 103.2M
   CGroup: /system.slice/mariadb.service
           ├─ 972 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─4815 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/m...

Aug 10 14:08:05 iZf8z0e7qk4ov06uno8ljrZ systemd[1]: Starting MariaDB database server...
Aug 10 14:08:06 iZf8z0e7qk4ov06uno8ljrZ mariadb-prepare-db-dir[881]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Aug 10 14:08:06 iZf8z0e7qk4ov06uno8ljrZ mariadb-prepare-db-dir[881]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Aug 10 14:08:06 iZf8z0e7qk4ov06uno8ljrZ mysqld_safe[972]: 240810 14:08:06 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Aug 10 14:08:06 iZf8z0e7qk4ov06uno8ljrZ mysqld_safe[972]: 240810 14:08:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Aug 10 14:08:08 iZf8z0e7qk4ov06uno8ljrZ systemd[1]: Started MariaDB database server.

再次输入命令:972为主端口

sudo kill -9 972

再次查看mariadb服务状态:发现已经停止,mysql容器也可以正常安装。

● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: failed (Result: signal) since Sat 2024-08-10 15:32:54 CST; 3s ago
  Process: 973 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 972 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=killed, signal=KILL)
  Process: 881 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 972 (code=killed, signal=KILL)

Aug 10 14:08:05 iZf8z0e7qk4ov06uno8ljrZ systemd[1]: Starting MariaDB database server...
Aug 10 14:08:06 iZf8z0e7qk4ov06uno8ljrZ mariadb-prepare-db-dir[881]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Aug 10 14:08:06 iZf8z0e7qk4ov06uno8ljrZ mariadb-prepare-db-dir[881]: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Aug 10 14:08:06 iZf8z0e7qk4ov06uno8ljrZ mysqld_safe[972]: 240810 14:08:06 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Aug 10 14:08:06 iZf8z0e7qk4ov06uno8ljrZ mysqld_safe[972]: 240810 14:08:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Aug 10 14:08:08 iZf8z0e7qk4ov06uno8ljrZ systemd[1]: Started MariaDB database server.
Aug 10 15:32:53 iZf8z0e7qk4ov06uno8ljrZ systemd[1]: mariadb.service: main process exited, code=killed, status=9/KILL
Aug 10 15:32:54 iZf8z0e7qk4ov06uno8ljrZ systemd[1]: Unit mariadb.service entered failed state.
Aug 10 15:32:54 iZf8z0e7qk4ov06uno8ljrZ systemd[1]: mariadb.service failed.

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐