decen
Hello, is it OK to choose 8.0-7.4 for the php version of phpmyadmin?
8.1 does not support phpmyadmin5.0

      aaPanel_Kern

      Thanks for the advice, I'll install PHP 8.0 and try to switch.
      If this will helps, I'll message you later.

        aaPanel_Kern

        That seems to help, Phpmyadmin works, but MySQL can't start, here is the screen

        also i got error thru phpmyadmin: Cannot log in to the MySQL server

            decen
            Execute the command to see what errors are displayed in the mysql log
            cat /www/server/data/*.err|grep -i -C 10 error

                decen
                Hi, have you done anything? Or did the server lose power? Prompt mysql-bin.000037 file does not exist
                Try to delete ./mysql-bin.000037 from the content of this /www/server/data/mysql-bin.index file, and then restart mysql. Can it be solved?
                It can be operated in the "File" interface of the panel
                cp /www/server/data/mysql-bin.index /www/server/data/mysql-bin.index
                /etc/init.d/mysqld restart

                    aaPanel_Kern

                    Deleted mysql-bin.000037 from the /www/server/data/mysql-bin.index file.
                    Restarted MySQL. Didn't help

                    As I understand server can't connect to MySQL,

                        decen
                        look again
                        Execute the command to see what errors are displayed in the mysql log
                        cat /www/server/data/*.err|grep -i -C 10 error

                            aaPanel_Kern

                            Yesterday upgraded apt-get upgrade:

                            Start-Date: 2022-08-02 18:02:27
                            Commandline: apt-get upgrade
                            Requested-By: ubuntu (1000)
                            Upgrade: update-notifier-common:amd64 (3.192.30.10, 3.192.30.11), apt:amd64 (2.0.8, 2.0.9), libkmod2:amd64 (27-1ubuntu2, 27-1ubuntu2.1), snapd:amd64 (2.54.3+20.04.1ubuntu0.3, 2.55.5+20.04), ubuntu-advantage-tools:amd64 (27.820.04.1, 27.920.04.1), isc-dhcp-common:amd64 (4.4.1-2.1ubuntu5.20.04.2, 4.4.1-2.1ubuntu5.20.04.3), libapt-pkg6.0:amd64 (2.0.8, 2.0.9), kmod:amd64 (27-1ubuntu2, 27-1ubuntu2.1), ec2-hibinit-agent:amd64 (1.0.0-0ubuntu9.1, 1.0.0-0ubuntu9.2), libkeyutils1:amd64 (1.6-6ubuntu1, 1.6-6ubuntu1.1), apt-utils:amd64 (2.0.8, 2.0.9), unattended-upgrades:amd64 (2.3ubuntu0.1, 2.3ubuntu0.3), isc-dhcp-client:amd64 (4.4.1-2.1ubuntu5.20.04.2, 4.4.1-2.1ubuntu5.20.04.3)
                            End-Date: 2022-08-02 18:03:08

                            Maybe after that MySQL stoped working

                                decen
                                Check out what mysql-bin files are in your directory, and can you tell me what you have done before?
                                ls /www/server/data/mysql-bin*

                                    decen

                                    Execute the command check out what mysql-bin files are in your directory
                                    ls /www/server/data/mysql-bin*

                                        decen
                                        There are no mysql-bin.000037 mysql-bin.000036 mysql-bin.000035 files in this directory.
                                        Try to remove the file mysql-bin.index and restart mysql
                                        mv /www/server/data/mysql-bin.index /tmp/mysql-bin.index
                                        /etc/init.d/mysqld restart

                                            aaPanel_Kern

                                            Solved! Everything works perfect.
                                            How to avoid to create this mysql-bin files?