【已解答】mysql启动不了

点击启动会显示启动成功然后还是关闭的状态。

[admin@iz2ze47t18bfjfvo9jih30z ~]$ sudo -i cat /www/server/data/*.err|grep -i -C 10 error
2021-08-02 11:20:17 2625 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 11:20:17 2625 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 11:20:17 2625 [Note] InnoDB: Waiting for purge to start
2021-08-02 11:20:17 2625 [Note] InnoDB: 5.6.49 started; log sequence number 1626044
2021-08-02 11:20:17 2625 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 11:20:17 2625 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 11:20:17 2625 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 11:20:17 2625 [Note] IPv6 is available.
2021-08-02 11:20:17 2625 [Note]   - '::' resolves to '::';
2021-08-02 11:20:17 2625 [Note] Server socket created on IP: '::'.
2021-08-02 11:20:17 2625 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 11:20:17 2625 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 11:20:17 2625 [ERROR] Aborting

2021-08-02 11:20:17 2625 [Note] Binlog end
2021-08-02 11:20:17 2625 [Note] Shutting down plugin 'partition'
2021-08-02 11:20:17 2625 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-08-02 11:20:17 2625 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 11:20:17 2625 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 11:20:17 2625 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 11:20:17 2625 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 11:20:17 2625 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 11:20:17 2625 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
--
2021-08-02 11:25:55 12693 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 11:25:55 12693 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 11:25:55 12693 [Note] InnoDB: Waiting for purge to start
2021-08-02 11:25:55 12693 [Note] InnoDB: 5.6.49 started; log sequence number 1626054
2021-08-02 11:25:55 12693 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 11:25:55 12693 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 11:25:55 12693 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 11:25:55 12693 [Note] IPv6 is available.
2021-08-02 11:25:55 12693 [Note]   - '::' resolves to '::';
2021-08-02 11:25:55 12693 [Note] Server socket created on IP: '::'.
2021-08-02 11:25:55 12693 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 11:25:55 12693 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 11:25:55 12693 [ERROR] Aborting

2021-08-02 11:25:55 12693 [Note] Binlog end
2021-08-02 11:25:55 12693 [Note] Shutting down plugin 'partition'
2021-08-02 11:25:55 12693 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-08-02 11:25:55 12693 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 11:25:55 12693 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 11:25:55 12693 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 11:25:55 12693 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 11:25:55 12693 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 11:25:55 12693 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
--
2021-08-02 11:44:28 23355 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 11:44:28 23355 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 11:44:28 23355 [Note] InnoDB: Waiting for purge to start
2021-08-02 11:44:28 23355 [Note] InnoDB: 5.6.50 started; log sequence number 1626064
2021-08-02 11:44:28 23355 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 11:44:28 23355 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 11:44:28 23355 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 11:44:28 23355 [Note] IPv6 is available.
2021-08-02 11:44:28 23355 [Note]   - '::' resolves to '::';
2021-08-02 11:44:28 23355 [Note] Server socket created on IP: '::'.
2021-08-02 11:44:28 23355 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 11:44:28 23355 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 11:44:28 23355 [ERROR] Aborting

2021-08-02 11:44:28 23355 [Note] Binlog end
2021-08-02 11:44:28 23355 [Note] Shutting down plugin 'partition'
2021-08-02 11:44:28 23355 [Note] Shutting down plugin 'ARCHIVE'
2021-08-02 11:44:28 23355 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 11:44:28 23355 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 11:44:28 23355 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 11:44:28 23355 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 11:44:28 23355 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 11:44:28 23355 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
--
2021-08-02 11:44:49 24020 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 11:44:49 24020 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 11:44:49 24020 [Note] InnoDB: Waiting for purge to start
2021-08-02 11:44:49 24020 [Note] InnoDB: 5.6.50 started; log sequence number 1626074
2021-08-02 11:44:49 24020 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 11:44:49 24020 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 11:44:49 24020 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 11:44:49 24020 [Note] IPv6 is available.
2021-08-02 11:44:49 24020 [Note]   - '::' resolves to '::';
2021-08-02 11:44:49 24020 [Note] Server socket created on IP: '::'.
2021-08-02 11:44:49 24020 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 11:44:49 24020 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 11:44:49 24020 [ERROR] Aborting

2021-08-02 11:44:49 24020 [Note] Binlog end
2021-08-02 11:44:49 24020 [Note] Shutting down plugin 'partition'
2021-08-02 11:44:49 24020 [Note] Shutting down plugin 'ARCHIVE'
2021-08-02 11:44:49 24020 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 11:44:49 24020 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 11:44:49 24020 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 11:44:49 24020 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 11:44:49 24020 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 11:44:49 24020 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
--
2021-08-02 11:45:08 24736 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 11:45:08 24736 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 11:45:08 24736 [Note] InnoDB: Waiting for purge to start
2021-08-02 11:45:08 24736 [Note] InnoDB: 5.6.50 started; log sequence number 1626084
2021-08-02 11:45:08 24736 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 11:45:08 24736 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 11:45:08 24736 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 11:45:08 24736 [Note] IPv6 is available.
2021-08-02 11:45:08 24736 [Note]   - '::' resolves to '::';
2021-08-02 11:45:08 24736 [Note] Server socket created on IP: '::'.
2021-08-02 11:45:08 24736 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 11:45:08 24736 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 11:45:08 24736 [ERROR] Aborting

2021-08-02 11:45:08 24736 [Note] Binlog end
2021-08-02 11:45:08 24736 [Note] Shutting down plugin 'partition'
2021-08-02 11:45:08 24736 [Note] Shutting down plugin 'ARCHIVE'
2021-08-02 11:45:08 24736 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 11:45:08 24736 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 11:45:08 24736 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 11:45:08 24736 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 11:45:08 24736 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 11:45:08 24736 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
--
2021-08-02 11:45:38 25399 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 11:45:38 25399 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 11:45:38 25399 [Note] InnoDB: Waiting for purge to start
2021-08-02 11:45:38 25399 [Note] InnoDB: 5.6.50 started; log sequence number 1626094
2021-08-02 11:45:38 25399 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 11:45:38 25399 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 11:45:38 25399 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 11:45:38 25399 [Note] IPv6 is available.
2021-08-02 11:45:38 25399 [Note]   - '::' resolves to '::';
2021-08-02 11:45:38 25399 [Note] Server socket created on IP: '::'.
2021-08-02 11:45:38 25399 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 11:45:38 25399 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 11:45:38 25399 [ERROR] Aborting

2021-08-02 11:45:38 25399 [Note] Binlog end
2021-08-02 11:45:38 25399 [Note] Shutting down plugin 'partition'
2021-08-02 11:45:38 25399 [Note] Shutting down plugin 'ARCHIVE'
2021-08-02 11:45:38 25399 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 11:45:38 25399 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 11:45:38 25399 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 11:45:38 25399 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 11:45:38 25399 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 11:45:38 25399 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
--
2021-08-02 11:48:21 26280 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 11:48:21 26280 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 11:48:21 26280 [Note] InnoDB: Waiting for purge to start
2021-08-02 11:48:22 26280 [Note] InnoDB: 5.6.50 started; log sequence number 1626104
2021-08-02 11:48:22 26280 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 11:48:22 26280 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 11:48:22 26280 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 11:48:22 26280 [Note] IPv6 is available.
2021-08-02 11:48:22 26280 [Note]   - '::' resolves to '::';
2021-08-02 11:48:22 26280 [Note] Server socket created on IP: '::'.
2021-08-02 11:48:22 26280 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 11:48:22 26280 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 11:48:22 26280 [ERROR] Aborting

2021-08-02 11:48:22 26280 [Note] Binlog end
2021-08-02 11:48:22 26280 [Note] Shutting down plugin 'partition'
2021-08-02 11:48:22 26280 [Note] Shutting down plugin 'ARCHIVE'
2021-08-02 11:48:22 26280 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 11:48:22 26280 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 11:48:22 26280 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 11:48:22 26280 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 11:48:22 26280 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 11:48:22 26280 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
--
2021-08-02 11:51:05 26972 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 11:51:05 26972 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 11:51:05 26972 [Note] InnoDB: Waiting for purge to start
2021-08-02 11:51:05 26972 [Note] InnoDB: 5.6.50 started; log sequence number 1626130
2021-08-02 11:51:05 26972 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 11:51:05 26972 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 11:51:05 26972 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 11:51:05 26972 [Note] IPv6 is available.
2021-08-02 11:51:05 26972 [Note]   - '::' resolves to '::';
2021-08-02 11:51:05 26972 [Note] Server socket created on IP: '::'.
2021-08-02 11:51:05 26972 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 11:51:05 26972 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 11:51:05 26972 [ERROR] Aborting

2021-08-02 11:51:05 26972 [Note] Binlog end
2021-08-02 11:51:05 26972 [Note] Shutting down plugin 'partition'
2021-08-02 11:51:05 26972 [Note] Shutting down plugin 'ARCHIVE'
2021-08-02 11:51:05 26972 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 11:51:05 26972 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 11:51:05 26972 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 11:51:05 26972 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 11:51:05 26972 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 11:51:05 26972 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
--
2021-08-02 12:25:01 27866 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 12:25:01 27866 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 12:25:01 27866 [Note] InnoDB: Waiting for purge to start
2021-08-02 12:25:01 27866 [Note] InnoDB: 5.6.50 started; log sequence number 1626140
2021-08-02 12:25:01 27866 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 12:25:01 27866 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 12:25:01 27866 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 12:25:01 27866 [Note] IPv6 is available.
2021-08-02 12:25:01 27866 [Note]   - '::' resolves to '::';
2021-08-02 12:25:01 27866 [Note] Server socket created on IP: '::'.
2021-08-02 12:25:01 27866 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 12:25:01 27866 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 12:25:01 27866 [ERROR] Aborting

2021-08-02 12:25:01 27866 [Note] Binlog end
2021-08-02 12:25:01 27866 [Note] Shutting down plugin 'partition'
2021-08-02 12:25:01 27866 [Note] Shutting down plugin 'ARCHIVE'
2021-08-02 12:25:01 27866 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 12:25:01 27866 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 12:25:01 27866 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 12:25:01 27866 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 12:25:01 27866 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 12:25:01 27866 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
--
2021-08-02 12:29:06 29117 [Note] InnoDB: Highest supported file format is Barracuda.
2021-08-02 12:29:06 29117 [Note] InnoDB: 128 rollback segment(s) are active.
2021-08-02 12:29:06 29117 [Note] InnoDB: Waiting for purge to start
2021-08-02 12:29:06 29117 [Note] InnoDB: 5.6.50 started; log sequence number 1626150
2021-08-02 12:29:06 29117 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2021-08-02 12:29:06 29117 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2021-08-02 12:29:06 29117 [Note] Server hostname (bind-address): '*'; port: 3306
2021-08-02 12:29:06 29117 [Note] IPv6 is available.
2021-08-02 12:29:06 29117 [Note]   - '::' resolves to '::';
2021-08-02 12:29:06 29117 [Note] Server socket created on IP: '::'.
2021-08-02 12:29:06 29117 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 12:29:06 29117 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 12:29:06 29117 [ERROR] Aborting

2021-08-02 12:29:06 29117 [Note] Binlog end
2021-08-02 12:29:06 29117 [Note] Shutting down plugin 'partition'
2021-08-02 12:29:06 29117 [Note] Shutting down plugin 'ARCHIVE'
2021-08-02 12:29:06 29117 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-08-02 12:29:06 29117 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-08-02 12:29:06 29117 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-08-02 12:29:06 29117 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-08-02 12:29:06 29117 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-08-02 12:29:06 29117 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

宝塔用户_wbrget 发表于 2021-8-2 12:36
[admin@iz2ze47t18bfjfvo9jih30z ~]$ sudo -i cat /www/server/data/*.err|grep -i -C 10 error
2021-08-02 ...

2021-08-02 12:29:06 29117 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2021-08-02 12:29:06 29117 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-08-02 12:29:06 29117 [ERROR] Aborting

这里提示是有另外一个程序占用了 3306 端口，您有其他的服务使用 3306 端口吗？

1. netstat -lntup|grep 3306

复制代码

SSH中root权限执行看下

我这边建了1000个数据库后，怎么启动也启动不了