aaPanel Docs

Appearance

Databases Related FAQs ​

Mysql root or user password is incorrect, please try to reset! ​

alt text

Tip: The MySQL password by aaPanel is wrong. Please try to reset the password using:

Databases --> MySQL --> Root Password.

Error establishing a database connection ​

alt text

  • Please check if the MySQL server is started? App Store --> Installed --> MySQL

  • Please check if the database name is correct? Databases --> MySQL --> Database Name

  • Please check if the user name of the database is correct? Databases --> MySQL --> Username Can try to log in using phpMyAdmin

  • Please check if the database password is correct? Databases --> MySQL --> Password Can try to log in using phpMyAdmin

  • Please check whether the database host connected to the website configuration file is correct? If it is localhost, try changing it to 127.0.0.1

mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) ​

  • Please check if the database name is correct? Databases --> MySQL --> Database Name

  • Please check if the user name of the database is correct? Databases --> MySQL --> Username

  • Please check if the database password is correct? Databases --> MySQL --> Password / Root Password You can try to reset the password

  • Please check whether the permissions of the database to allow connection are correct? Databases --> MySQL --> Permission

Mysql/Mariadb Innodb Storage Engine Damage Solution ​

forcing-innodb-recovery

innodb_force_recovery

Please check out the tutorial Mysql/Mariadb Innodb Storage Engine Damage Solution

Failed to open log (file './mysql-bin.000004', errno 2) ​

2024-12-24T05:23:57.738940Z 0 [Note] InnoDB: Buffer pool(s) load completed at 241224 7:23:57
mysqld: File './mysql-bin.000004' not found (Errcode: 2 - No such file or directory)
2024-12-24T05:23:57.739719Z 0 [ERROR] Failed to open log (file './mysql-bin.000004', errno 2)
2024-12-24T05:23:57.739723Z 0 [ERROR] Could not open log file
2024-12-24T05:23:57.739726Z 0 [ERROR] Can't init tc log
2024-12-24T05:23:57.739728Z 0 [ERROR] Aborting

  1. Operation after server snapshot backup

  2. Remove ./mysql-bin.000004 from the contents of the /www/server/data/mysql-bin.index file

    If there are still prompts such as ./mysql-bin.000003, they also need to be deleted from the contents of the mysql-bin.index file.

  3. Restart mysql and check whether it is running normally. If there are still errors, please check the logs to resolve them.

How to view MySQL error log? ​

  1. View from the aaPanel interface: App Store --> MySQL --> Log

  2. Use the command line to view: cat /www/server/data/*.err|grep -i -C 10 error

Feedback or Suggestions ​

If you encounter problems or suggestions during use, please contact us through the following methods:

  • (Please describe in detail or provide screenshots)
  1. Forum: https://www.aapanel.com/forum
  2. Email: [email protected]