MySQL does not work !

[matveybaranov09]

Hello, dear developers.

I have a problem: after a recent update, the MySQL server (MariaDB) does not work!

1. When you enter the mysql or mariadb command, the following error is displayed:

ERROR 2002 (HY000): Can't connect to local server through socket '/data/data/com.termux/files/usr/var/run/mysqld.sock' (111)

2. When you try to manually start the MariaDb server (mysqld or mariadbd command), the following error is displayed:

2024-06-18 11:24:20 0 [Note] Starting MariaDB 11.4.2-MariaDB source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 12218
2024-06-18 11:24:20 0 [ERROR] mysqld: Can't lock aria control file '/data/data/com.termux/files/usr/var/lib/mysql/aria_log_control' for exclusive use, error : 11. Will retry for 30 seconds
2024-06-18 11:24:41 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
2024-06-18 11:24:41 0 [Note] InnoDB: Number of transaction pools: 1
2024-06-18 11:24:41 0 [Note] InnoDB: Using generic crc32 instructions
2024-06-18 11:24:41 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-06-18 11:24:41 0 [Note] InnoDB: Completed initialization of buffer pool
2024-06-18 11:24:41 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-06-18 11:24:41 0 [Note] InnoDB: End of log at LSN=37808
2024-06-18 11:24:41 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-06-18 11:24:41 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-06-18 11:24:41 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait...
2024-06-18 11:24:41 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-06-18 11:24:41 0 [Note] InnoDB: log sequence number 37808; transaction id 4
2024-06-18 11:24:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-06-18 11:24:41 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist." Some plugins may not be loaded
2024-06-18 11:24:41 0 [Note] InnoDB: Loading buffer pool(s) from /data/data/com.termux/files/usr/var/lib/mysql/ib_buffer_pool
2024-06-18 11:24:41 0 [Note] InnoDB: Buffer pool(s) load completed at 240618 11:24:41
2024-06-18 11:24:41 0 [ERROR] mysqld: File './ddl_recovery.log' not found (Errcode: 2 "No such file or directory")
2024-06-18 11:24:41 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-06-18 11:24:53 0 [Note] Server socket created on IP: '::'.
2024-06-18 11:24:53 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-06-18 11:24:53 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
2024-06-18 11:24:53 0 [ERROR] Abortion

3. When you try to log into PhpMyAdmin, the following error is displayed.

Help me please solve this problem.

[armandwipangestu]

i think this error because the package mysql or mariadb updated from termux repository, so i can't help if the problem is that. You must be report to the Termux Telegram or Reddit or maybe open issue on Termux repository

because currently i'm still using the old version and the lamp script still work