this happened to me too, is there a way to fix it?

how to Fix This error - Cannot log in to the MySQL server

lnhax

aaPanel_Jose

lnhax
Is the webserver you use ols? If so, can you provide me with the panel login? I have seen many such problems in the forum but I cannot reproduce it on my own server

Toyota

I have the same problem.

I can log in to the site database, but I cannot log in to the root database.

When saving. I rebooted Mysql. I rebooted the server. Rebooted pxp, rebooted nginx. Nothing helps.

aaPanel_Kern

Toyota
Hello, when you save, an error is prompted, as shown in the figure at least 8M

It is recommended that you modify the root password of the database and log in with the new password.

Toyota

I did that too.
For some reason, the server can not connect to MYSQL.
But to connect to the database of a particular site - I can.
But to connect to the root database I can not.

In the firewall the port is open.

aaPanel_Kern

Toyota
Hello, have you changed the root password? When you log in to phpmyadmin, do you paste it or type it one by one?

Toyota

aaPanel_Kern I copy and paste.

I think there is a problem with access, because the Mysql plugin itself does not work.
And I can not delete the plugin, as I have already moved the site to a new server and removed the old one...

Toyota

I have already fixed the panel, restarted the panel, restarted the server.
Restarted the Mysql plugin, changed the password. Nothing helps. I think that only uninstall and reinstall - will help.
But I can not remove the Mysql plugin 🙁

aaPanel_Kern

Toyota
Hi,can you provide us with your aapanel information if it is convenient? If so, please send it to 1096308852@qq.com, thank you.

mindzor

aaPanel_Kern i have same trouble here.

MariaDB Log
`Server version: 10.4.12-MariaDB-log
key_buffer_size=134217728
read_buffer_size=2097152
max_used_connections=0
max_threads=502
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2199644 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x49000
2024-05-22 22:11:34 0 [ERROR] mysqld: Can't lock aria control file '/www/server/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2024-05-22 22:12:05 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/www/server/data/aria_log_control'
2024-05-22 22:12:05 0 [ERROR] Plugin 'Aria' init function returned error.
2024-05-22 22:12:05 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-05-22 22:12:05 0 [Note] InnoDB: Using Linux native AIO
2024-05-22 22:12:05 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-05-22 22:12:05 0 [Note] InnoDB: Uses event mutexes
2024-05-22 22:12:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-22 22:12:05 0 [Note] InnoDB: Number of pools: 1
2024-05-22 22:12:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-22 22:12:05 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2024-05-22 22:12:05 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2024-05-22 22:12:05 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-22 22:12:05 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-05-22 22:12:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1277795530
2024-05-22 22:12:05 0 [Note] InnoDB: Last binlog file './mysql-bin.000006', position 25098535
2024-05-22 22:12:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-22 22:12:05 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-05-22 22:12:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-22 22:12:05 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-22 22:12:05 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2024-05-22 22:12:05 0 [Note] InnoDB: Waiting for purge to start
2024-05-22 22:12:05 0 [Note] InnoDB: 10.4.12 started; log sequence number 1277795578; transaction id 203632
2024-05-22 22:12:05 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2024-05-22 22:12:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-22 22:12:05 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-05-22 22:12:05 0 [ERROR] Failed to initialize plugins.
2024-05-22 22:12:05 0 [ERROR] Aborting
2024-05-22 22:17:17 0 [ERROR] mysqld: Can't lock aria control file '/www/server/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2024-05-22 22:17:25 0 [Note] InnoDB: Using Linux native AIO
2024-05-22 22:17:25 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-05-22 22:17:25 0 [Note] InnoDB: Uses event mutexes
2024-05-22 22:17:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-22 22:17:25 0 [Note] InnoDB: Number of pools: 1
2024-05-22 22:17:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-22 22:17:25 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2024-05-22 22:17:25 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2024-05-22 22:17:25 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-22 22:17:25 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-05-22 22:17:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-22 22:17:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-22 22:17:25 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-22 22:17:25 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2024-05-22 22:17:25 0 [Note] InnoDB: 10.4.12 started; log sequence number 1277795674; transaction id 203632
2024-05-22 22:17:25 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2024-05-22 22:17:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-22 22:17:25 0 [Note] Recovering after a crash using mysql-bin
2024-05-22 22:17:25 0 [Note] Starting crash recovery...
2024-05-22 22:17:25 0 [Note] Crash recovery finished.
2024-05-22 22:17:25 0 [Note] Server socket created on IP: '::'.
2024-05-22 22:17:25 0 [Note] Reading of all Master_info entries succeeded
2024-05-22 22:17:25 0 [Note] Added new Master_info '' to hash table
2024-05-22 22:17:25 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.4.12-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2024-05-22 22:17:25 0 [Note] InnoDB: Buffer pool(s) load completed at 240522 22:17:25
2024-05-22 22:17:26 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2024-05-22 22:17:39 10 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2024-05-22 22:18:38 11 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2024-05-22 22:18:38 12 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2024-05-22 22:18:51 0 [Note] /www/server/mysql/bin/mysqld (initiated by: unknown): Normal shutdown
2024-05-22 22:18:51 0 [Note] Event Scheduler: Purging the queue. 0 events
2024-05-22 22:18:51 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-22 22:18:51 0 [Note] InnoDB: Starting shutdown...
2024-05-22 22:18:51 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2024-05-22 22:18:51 0 [Note] InnoDB: Instance 0, restricted to 8015 pages due to innodb_buf_pool_dump_pct=25
2024-05-22 22:18:51 0 [Note] InnoDB: Buffer pool(s) dump completed at 240522 22:18:51
2024-05-22 22:18:53 0 [Note] InnoDB: Shutdown completed; log sequence number 1277795683; transaction id 203633
2024-05-22 22:18:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-05-22 22:18:53 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

2024-05-22 22:18:54 0 [Note] InnoDB: Using Linux native AIO
2024-05-22 22:18:54 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-05-22 22:18:54 0 [Note] InnoDB: Uses event mutexes
2024-05-22 22:18:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-22 22:18:54 0 [Note] InnoDB: Number of pools: 1
2024-05-22 22:18:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-22 22:18:54 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2024-05-22 22:18:54 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2024-05-22 22:18:54 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-22 22:18:54 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-05-22 22:18:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-22 22:18:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-22 22:18:54 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-22 22:18:54 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2024-05-22 22:18:54 0 [Note] InnoDB: Waiting for purge to start
2024-05-22 22:18:54 0 [Note] InnoDB: 10.4.12 started; log sequence number 1277795683; transaction id 203632
2024-05-22 22:18:54 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2024-05-22 22:18:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-22 22:18:54 0 [Note] Server socket created on IP: '::'.
2024-05-22 22:18:54 0 [Note] Reading of all Master_info entries succeeded
2024-05-22 22:18:54 0 [Note] Added new Master_info '' to hash table
2024-05-22 22:18:54 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.4.12-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2024-05-22 22:18:54 0 [Note] InnoDB: Buffer pool(s) load completed at 240522 22:18:54
2024-05-22 22:18:55 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2024-05-22 22:19:16 10 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2024-05-22 22:19:25 11 [Warning] Access denied for user 'root'@'localhost' (using password: YES)`

aaPanel_Kern

Hello, is the problem solved? Please try to change the root password in the database interface. Is it normal?

mindzor