Hello

Database creation - deletion - password update

I am having trouble with operations.

Create

Del

Change Pass

I am changing the root user password but cannot login.

    hasokeyk
    Thank you, we have found this problem, the cause of this problem is that using the panel reset will fail after modifying the root password in the mysql terminal, we are repairing

    23 days later

    akreptv
    can you tell me what is the version of the panel you are using, and what is the system version?

    6 days later
    a month later

    after changing the root password in aapanel I get: ERROR to connect database, pls check database status!

      guid
      Can you log in with phpmyadmin? Or check the database status

      • guid replied to this.

        aaPanel_Jose
        after installation, mysql service ist not running (pause sign) and I cant start the service

        on ssh i am getting
        ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

        in the aaPanel mysql config file I have these default settings

        [client]
        #password = your_password
        port = 3306
        socket = /tmp/mysql.sock

        [mysqld]
        port = 3306
        socket = /tmp/mysql.sock
        datadir = /www/server/data

          guid
          can you show me the mysql log?
          tail -n 50 /www/server/data/yourhostname.err

          191024 4:01:38 [Note] Plugin 'FEDERATED' is disabled.
          191024 4:01:38 InnoDB: The InnoDB memory heap is disabled
          191024 4:01:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
          191024 4:01:38 InnoDB: Compressed tables use zlib 1.2.11
          191024 4:01:38 InnoDB: Initializing buffer pool, size = 4.0G
          191024 4:01:38 InnoDB: Completed initialization of buffer pool
          InnoDB: Error: space header page consists of zero bytes in data file /www/server/data/ibdata1
          191024 4:01:39 InnoDB: Could not open or create data files.
          191024 4:01:39 InnoDB: If you tried to add new data files, and it failed here,
          191024 4:01:39 InnoDB: you should now edit innodb_data_file_path in my.cnf back
          191024 4:01:39 InnoDB: to what it was, and remove the new ibdata files InnoDB created
          191024 4:01:39 InnoDB: in this failed attempt. InnoDB only wrote those files full of
          191024 4:01:39 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
          191024 4:01:39 InnoDB: remove old data files which contain your precious data!
          191024 4:01:39 [ERROR] Plugin 'InnoDB' init function returned error.
          191024 4:01:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
          191024 4:01:39 [ERROR] Unknown/unsupported storage engine: InnoDB
          191024 4:01:39 [ERROR] Aborting

          191024 4:01:39 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

            no its

            -rw-rw---- 1 mysql mysql 10485760 Oct 24 03:52 ibdata1

              guid
              I see your error log saying that it is 0kb, can I log in to your panel to help you check it?

              • guid replied to this.

                solved, many thx. Jose. Excellent support!
                Beginner mistake: Forgot to add more diskspace to the installation. That corrupted the mysql files.

                Connect with us: πŸ“¨ Telegram πŸ’¬ Discord Email: support@aapanel.com