Trying to change the access permissions to a database, from localhost to everyone...

I hope this will help you to debug errors.
Best regards!

    Hello, please check whether the root password of the database interface is correct? You can try to build a test library. If it is incorrect, try to reset the root password.

    sdesergi

      Hi,

      You mean phpmyadmin? I don't use that interface, only the mysql app.

        5 days later

        aaPanel_Kern

        How do I know if the root password is correct? In the aaPanel interface I can only check this password and reset it. I don't know if it's correct because I've never had to use it. Can I reset it without it breaking the operation of the databases that are currently running?

          Just add a test database directly and you will know
          If you are afraid of problems, it is recommended that you make a server snapshot backup first.

          sdesergi

            aaPanel_Kern

            I have already done the test. I can change permissions without errors on new databases, but not on old databases.
            Can you confirm that this will be solved by updating the MYSQL root password?

              aaPanel_Kern

              phpmyadmin isn't installed. I meant reset the password from aaPanel.

              Hello, please check whether the root password of the database interface is correct? You can try to build a test library. If it is incorrect, try to reset the root password

              I have created the database correctly. So... should I still reset the root password from aaPanel? Will that fix the error? If not... How can I fix the error that does not allow me to change the access permissions to the existing databases?

              Thanks

                If you can create a database directly from aapanel, it means the password is correct. It is recommended that you synchronize the database from the server to aapanel, or use phpmyadmin to check whether there is a related database?

                sdesergi

                  aaPanel_Kern

                  So... the password is correct. I don't understand the need for synchronisation. The databases are on the same server that runs the panel.

                  Looking at the error I can read...

                  TypeError: list indices must be integers or slices, not str

                  I'm not an expert, but that makes me think of some error in the code, specifically the type of variable defined.

                    sdesergi
                    Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
                    It is recommended to fill in the following
                    Post link:
                    SSH IP address, account password and port:
                    aapanel login link address and account password:
                    Detailed problem description:

                    No post link will not be able to know which user's information is, and the problem will not be processed

                    6 months later

                    Well, it seems that the problem has fixed itself, probably thanks to one of the updates. So, even without knowing the cause of the problem, thanks for continuing to debug the panel.

                    SerGi