amh - 新加了一个数据库，改了一下配置就报No such file or directory该怎么解决？

Question

命令启动MySQL就会报错

 [root@CentOS ~]# amh mysql start
=============================================================
 [Linux] AMH 7.0
 http://amh.sh

[mysql start]
=============================================================
=============================================================
 [Linux] AMH 7.0
 http://amh.sh

[mysql-generic-5.5 start]
=============================================================
mysql-generic-5.5
[OK] mysql-generic-5.5 is already installed.
Starting MySQL... ERROR! The server quit without updating PID file (/home/usrdata/mysql-generic-5.5/mysql.pid).
230526 18:03:17 [Note] Plugin 'InnoDB' is disabled.
230526 18:03:17 [Note] Event Scheduler: Loaded 0 events
230526 18:03:17 [Note] /usr/local/mysql-generic-5.5/bin/mysqld: ready for connections.
Version: '5.5.62-log'  socket: '/tmp/mysql-generic-5.5.sock'  port: 0  Source distribution
230526 18:13:25 [Note] /usr/local/mysql-generic-5.5/bin/mysqld: Normal shutdown

230526 18:13:25 [Note] Event Scheduler: Purging the queue. 0 events
230526 18:13:27 [Warning] /usr/local/mysql-generic-5.5/bin/mysqld: Forcing close of thread 861  user: 'root'

230526 18:13:27 [Warning] /usr/local/mysql-generic-5.5/bin/mysqld: Forcing close of thread 860  user: 'root'

230526 18:13:27 [Warning] /usr/local/mysql-generic-5.5/bin/mysqld: Forcing close of thread 859  user: 'root'

230526 18:13:27 [Warning] /usr/local/mysql-generic-5.5/bin/mysqld: Forcing close of thread 858  user: 'root'

230526 18:13:27 [Warning] /usr/local/mysql-generic-5.5/bin/mysqld: Forcing close of thread 857  user: 'root'

230526 18:13:27 [Note] /usr/local/mysql-generic-5.5/bin/mysqld: Shutdown complete

230526 18:13:28 InnoDB: The InnoDB memory heap is disabled
230526 18:13:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230526 18:13:28 InnoDB: Compressed tables use zlib 1.2.11
230526 18:13:28 InnoDB: Initializing buffer pool, size = 128.0M
230526 18:13:28 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
230526 18:13:28  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
230526 18:13:28  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
230526 18:13:28  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
230526 18:13:29  InnoDB: Waiting for the background threads to start
230526 18:13:30 InnoDB: 5.5.62 started; log sequence number 0
230526 18:13:30 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
230526 18:13:30 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
230526 18:13:30 [Note] Server socket created on IP: '0.0.0.0'.
230526 18:13:30 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
230526 18:13:30 [ERROR] Do you already have another mysqld server running on port: 3306 ?
230526 18:13:30 [ERROR] Aborting

230526 18:13:30  InnoDB: Starting shutdown...
230526 18:13:31  InnoDB: Shutdown completed; log sequence number 1595675
230526 18:13:31 [Note] /usr/local/mysql-generic-5.5/bin/mysqld: Shutdown complete

230526 18:13:48 InnoDB: The InnoDB memory heap is disabled
230526 18:13:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230526 18:13:48 InnoDB: Compressed tables use zlib 1.2.11
230526 18:13:48 InnoDB: Initializing buffer pool, size = 128.0M
230526 18:13:48 InnoDB: Completed initialization of buffer pool
230526 18:13:48 InnoDB: highest supported file format is Barracuda.
230526 18:13:48  InnoDB: Waiting for the background threads to start
230526 18:13:49 InnoDB: 5.5.62 started; log sequence number 1595675
230526 18:13:49 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
230526 18:13:49 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
230526 18:13:49 [Note] Server socket created on IP: '0.0.0.0'.
230526 18:13:49 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
230526 18:13:49 [ERROR] Do you already have another mysqld server running on port: 3306 ?
230526 18:13:49 [ERROR] Aborting

230526 18:13:49  InnoDB: Starting shutdown...
230526 18:13:50  InnoDB: Shutdown completed; log sequence number 1595675
230526 18:13:50 [Note] /usr/local/mysql-generic-5.5/bin/mysqld: Shutdown complete

230527  8:57:31 InnoDB: The InnoDB memory heap is disabled
230527  8:57:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230527  8:57:31 InnoDB: Compressed tables use zlib 1.2.11
230527  8:57:31 InnoDB: Initializing buffer pool, size = 128.0M
230527  8:57:31 InnoDB: Completed initialization of buffer pool
230527  8:57:31 InnoDB: highest supported file format is Barracuda.
230527  8:57:31  InnoDB: Waiting for the background threads to start
230527  8:57:32 InnoDB: 5.5.62 started; log sequence number 1595675
230527  8:57:32 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
230527  8:57:32 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
230527  8:57:32 [Note] Server socket created on IP: '0.0.0.0'.
230527  8:57:32 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
230527  8:57:32 [ERROR] Do you already have another mysqld server running on port: 3306 ?
230527  8:57:32 [ERROR] Aborting

230527  8:57:32  InnoDB: Starting shutdown...
230527  8:57:33  InnoDB: Shutdown completed; log sequence number 1595675
230527  8:57:33 [Note] /usr/local/mysql-generic-5.5/bin/mysqld: Shutdown complete

230527  9:18:54 InnoDB: The InnoDB memory heap is disabled
230527  9:18:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230527  9:18:54 InnoDB: Compressed tables use zlib 1.2.11
230527  9:18:54 InnoDB: Initializing buffer pool, size = 128.0M
230527  9:18:54 InnoDB: Completed initialization of buffer pool
230527  9:18:54 InnoDB: highest supported file format is Barracuda.
230527  9:18:54  InnoDB: Waiting for the background threads to start
230527  9:18:55 InnoDB: 5.5.62 started; log sequence number 1595675
230527  9:18:55 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
230527  9:18:55 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
230527  9:18:55 [Note] Server socket created on IP: '0.0.0.0'.
230527  9:18:55 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
230527  9:18:55 [ERROR] Do you already have another mysqld server running on port: 3306 ?
230527  9:18:55 [ERROR] Aborting

230527  9:18:55  InnoDB: Starting shutdown...
230527  9:18:55  InnoDB: Shutdown completed; log sequence number 1595675
230527  9:18:55 [Note] /usr/local/mysql-generic-5.5/bin/mysqld: Shutdown complete

230527  9:23:03 InnoDB: The InnoDB memory heap is disabled
230527  9:23:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
230527  9:23:03 InnoDB: Compressed tables use zlib 1.2.11
230527  9:23:03 InnoDB: Initializing buffer pool, size = 128.0M
230527  9:23:03 InnoDB: Completed initialization of buffer pool
230527  9:23:03 InnoDB: highest supported file format is Barracuda.
230527  9:23:03  InnoDB: Waiting for the background threads to start
230527  9:23:04 InnoDB: 5.5.62 started; log sequence number 1595675
230527  9:23:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
230527  9:23:04 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
230527  9:23:04 [Note] Server socket created on IP: '0.0.0.0'.
230527  9:23:04 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
230527  9:23:04 [ERROR] Do you already have another mysqld server running on port: 3306 ?
230527  9:23:04 [ERROR] Aborting

230527  9:23:04  InnoDB: Starting shutdown...
230527  9:23:04  InnoDB: Shutdown completed; log sequence number 1595675
230527  9:23:04 [Note] /usr/local/mysql-generic-5.5/bin/mysqld: Shutdown complete

[Error] mysql-generic-5.5 start failed.

Answer 1

亲，报错是端口已经占用。如果有使用多个mysql，并都有开启端口监听的话，要分别用不同端口才行，如一个用3306另一个用3307等，选项旁边也有说明。

你可以停止你当前所有的mysql，单独启动其中一个mysql，再在面板修改mysql端口，
可以使用命令：
amh mysql stop 或
amh mysql-5.6 stop
amh mysql-generic-5.5 start