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.
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
hasokeyk
Upgrading the panel to the latest version will fix this problem
Thanks
I have the same problem
akreptv
can you tell me what is the version of the panel you are using, and what is the system version?
i have the same problem..my version 6.2.6
DendyAndika
Have you tried resetting the mysql root password?
thx for your advice..problem solved
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
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
guid
This file is 0 kb?
ls -al /www/server/data/ibdata1
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?
aaPanel_Jose yes, how I can give you the login data?
guid
Please send it to my email zhwyeah@gmail.com
solved, many thx. Jose. Excellent support!
Beginner mistake: Forgot to add more diskspace to the installation. That corrupted the mysql files.