Command "/usr/bin/sudo /bin/systemctl restart 'mysql'" failed: the process exceeded the timeout of 30 seconds

ERROR: Can't lock aria control file '/home/mysql/aria_log_control'
ERROR: Unable to lock ./ibdata1
ERROR: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

I had the exact same issue and found the root cause. CloudPanel starts MariaDB in --skip-grant-tables mode when troubleshooting, and that leftover process was blocking the real MariaDB start attempt.
Here's how I fixed it step by step:

---

Step-by-step solution (MariaDB fails due to file locks)

1. Kill all MariaDB/MySQL related processes:
   
   CODE_BLOCK_0
2. Make sure everything is cleaned up:
   
   

   ps aux | grep -i mysql

   
   

   
   Only the grep line should appear.
   

3. Start MariaDB cleanly:
   
   CODE_BLOCK_2
4. Check its status:
   
   CODE_BLOCK_3
5. Then connect using your new root password (if previously reset):
   
   CODE_BLOCK_4

In my case, the issue was caused by a lingering mariadbd process that was still locking aria_log_control and ibdata1. Killing it fully and starting fresh solved everything.