Fresh postinstall mysql is not working

Hi, my hardware is : Raspberry Pi
YunoHost version:4.1.7.2
I have access to my server : through the webadmin and direct access via keyboard / screen
After postinstal I have done just first user and diagnosis.
Logs :

journalctl

– Logs begin at Sun 2021-02-21 06:17:01 GMT, end at Sun 2021-02-21 06:36:23 GMT. –
Feb 21 06:17:35 systemd[1]: Starting MariaDB 10.3.27 database server…
Feb 21 06:17:37 mysqld[803]: 2021-02-21 6:17:37 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 803 …
Feb 21 06:17:37 mysqld[803]: 2021-02-21 6:17:37 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32186)
Feb 21 06:17:38 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 21 06:17:38 systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Feb 21 06:17:38 systemd[1]: Failed to start MariaDB 10.3.27 database server.
Feb 21 06:22:54 systemd[1]: Starting MariaDB 10.3.27 database server…
Feb 21 06:22:54 mysqld[1293]: 2021-02-21 6:22:54 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 1293 …
Feb 21 06:22:54 mysqld[1293]: 2021-02-21 6:22:54 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32186)
Feb 21 06:22:55 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 21 06:22:55 systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Feb 21 06:22:55 systemd[1]: Failed to start MariaDB 10.3.27 database server.

/var/log/mysql/error.log

2021-02-21 6:17:37 0 [Note] InnoDB: Using generic crc32 instructions
2021-02-21 6:17:37 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-02-21 6:17:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-21 6:17:37 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-21 6:17:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=48579
2021-02-21 6:17:38 0 [Note] InnoDB: Starting final batch to recover 13 pages from redo log.
2021-02-21 6:17:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-21 6:17:38 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-02-21 6:17:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-21 6:17:38 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-02-21 6:17:38 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2021-02-21 6:17:38 0 [Note] InnoDB: Waiting for purge to start
2021-02-21 6:17:38 0 [Note] InnoDB: 10.3.27 started; log sequence number 1601327; transaction id 8
2021-02-21 6:17:38 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2021-02-21 6:17:38 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-02-21 6:17:38 0 [Note] Recovering after a crash using tc.log
2021-02-21 6:17:38 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-02-21 6:17:38 0 [Note] InnoDB: Cannot open ‘/var/lib/mysql/ib_buffer_pool’ for reading: No such file or directory
2021-02-21 6:17:38 0 [Note] Starting crash recovery…
2021-02-21 6:17:38 0 [Note] Crash recovery finished.
2021-02-21 6:17:38 0 [ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist
2021-02-21 6:17:38 0 [Note] Server socket created on IP: ‘127.0.0.1’.
2021-02-21 6:17:38 0 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
2021-02-21 6:22:54 0 [Note] InnoDB: Using Linux native AIO
2021-02-21 6:22:54 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-02-21 6:22:54 0 [Note] InnoDB: Uses event mutexes
2021-02-21 6:22:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-21 6:22:54 0 [Note] InnoDB: Number of pools: 1
2021-02-21 6:22:54 0 [Note] InnoDB: Using generic crc32 instructions
2021-02-21 6:22:54 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-02-21 6:22:54 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-21 6:22:54 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-21 6:22:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=48579
2021-02-21 6:22:55 0 [Note] InnoDB: Starting final batch to recover 13 pages from redo log.
2021-02-21 6:22:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-21 6:22:55 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-02-21 6:22:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-21 6:22:55 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-02-21 6:22:55 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2021-02-21 6:22:55 0 [Note] InnoDB: 10.3.27 started; log sequence number 1601327; transaction id 8
2021-02-21 6:22:55 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-02-21 6:22:55 0 [Note] InnoDB: Cannot open ‘/var/lib/mysql/ib_buffer_pool’ for reading: No such file or directory
2021-02-21 6:22:55 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2021-02-21 6:22:55 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-02-21 6:22:55 0 [Note] Recovering after a crash using tc.log
2021-02-21 6:22:55 0 [Note] Starting crash recovery…
2021-02-21 6:22:55 0 [Note] Crash recovery finished.
2021-02-21 6:22:55 0 [ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist
2021-02-21 6:22:55 0 [Note] Server socket created on IP: ‘127.0.0.1’.
2021-02-21 6:22:55 0 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.