美文网首页
mysql启动失败,端口3306被占用

mysql启动失败,端口3306被占用

作者: 王侦 | 来源:发表于2020-05-22 10:03 被阅读0次
2020-05-22T01:55:17.332085Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2020-05-22T01:55:17.332088Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-05-22T01:55:17.332094Z 0 [ERROR] Aborting

查看端口占用情况

[root@izbp15dzsx0qokz9qdqojkz ~]# netstat -tunlp | grep mysql
tcp6       0      0 :::3306                 :::*                    LISTEN      18941/mysqld        
[root@izbp15dzsx0qokz9qdqojkz ~]# kill -9 18941

启动mysql:

[root@izbp15dzsx0qokz9qdqojkz ~]# systemctl start mysqld.service
[root@izbp15dzsx0qokz9qdqojkz ~]# ps aux |grep mysql*
root       356  0.0  0.0 112712   988 pts/0    S+   10:02   0:00 grep --color=auto mysql57-community-release-el7-10.noarch.rpm
[root@izbp15dzsx0qokz9qdqojkz ~]# ps aux |grep mysqld
root       360  0.0  0.0 112712   964 pts/0    S+   10:02   0:00 grep --color=auto mysqld
root     19373  0.0  0.0 107976   588 pts/1    T    09:07   0:00 cat /var/log/mysqld.log
root     19533  0.0  0.0 107956   648 pts/1    T    09:09   0:00 tailf /var/log/mysqld.log
root     27605  0.0  0.0 667308  2740 pts/2    T    09:54   0:00 systemctl status mysqld.service
mysql    32397  0.1  4.3 1122096 167372 ?      Sl   09:58   0:00 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

[root@izbp15dzsx0qokz9qdqojkz ~]# systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2020-05-22 09:58:19 CST; 3min 18s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 32394 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 32376 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 32397 (mysqld)
   CGroup: /system.slice/mysqld.service
           └─32397 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

May 22 09:58:19 izbp15dzsx0qokz9qdqojkz systemd[1]: Starting MySQL Server...
May 22 09:58:19 izbp15dzsx0qokz9qdqojkz systemd[1]: Started MySQL Server.

相关文章

网友评论

      本文标题:mysql启动失败,端口3306被占用

      本文链接:https://www.haomeiwen.com/subject/uegfahtx.html