amh面板默认的数据库起不来了？

Question

2023-01-27 19:04:04 22682 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql-5.6/bin/mysqld: Table 'plugin' is read only
2023-01-27 19:04:04 22682 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2023-01-27 19:04:04 22682 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-01-27 19:04:04 22682 [Note] InnoDB: The InnoDB memory heap is disabled
2023-01-27 19:04:04 22682 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-01-27 19:04:04 22682 [Note] InnoDB: Memory barrier is not used
2023-01-27 19:04:04 22682 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-27 19:04:04 22682 [Note] InnoDB: Using CPU crc32 instructions
2023-01-27 19:04:04 22682 [Note] InnoDB: Initializing buffer pool, size = 768.0M
2023-01-27 19:04:04 22682 [Note] InnoDB: Completed initialization of buffer pool
2023-01-27 19:04:04 22682 [Note] InnoDB: Highest supported file format is Barracuda.
2023-01-27 19:04:04 22682 [Note] InnoDB: 128 rollback segment(s) are active.
2023-01-27 19:04:04 22682 [Note] InnoDB: Waiting for purge to start
2023-01-27 19:04:04 22682 [Note] InnoDB: 5.6.51 started; log sequence number 17470809
2023-01-27 19:04:04 22682 [Note] Recovering after a crash using mysql-bin
2023-01-27 19:04:04 22682 [Note] Starting crash recovery...
2023-01-27 19:04:04 22682 [Note] Crash recovery finished.
2023-01-27 19:04:04 22682 [Note] RSA private key file not found: /home/usrdata/mysql-5.6//private_key.pem. Some authentication plugins will not work.
2023-01-27 19:04:04 22682 [Note] RSA public key file not found: /home/usrdata/mysql-5.6//public_key.pem. Some authentication plugins will not work.
2023-01-27 19:04:04 22682 [Note] Server hostname (bind-address): '*'; port: 3306
2023-01-27 19:04:04 22682 [Note] IPv6 is available.
2023-01-27 19:04:04 22682 [Note]   - '::' resolves to '::';
2023-01-27 19:04:04 22682 [Note] Server socket created on IP: '::'.
2023-01-27 19:04:04 22682 [Warning] Few location(s) are inaccessible while checking PID filepath.
2023-01-27 19:04:04 22682 [ERROR] /usr/local/mysql-5.6/bin/mysqld: Can't create/write to file '/home/usrdata/mysql-5.6/mysql.pid' (Errcode: 13 - Permission denied)
2023-01-27 19:04:04 22682 [ERROR] Can't start server: can't create PID file: Permission denied
[Error] mysql-5.6 start failed.

使用 amh mysql-5.6 start 报以上错误

Answer 1

亲，看报错无法在 /home/usrdata/mysql-5.6/ 目录写入文件，是否改过权限，用命令改看看：
chmod -R 755 /home/usrdata/mysql-5.6/
chown -R mysql:mysql /home/usrdata/mysql-5.6/