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

Database password is incorrect! Problem

hasokeyk

Thanks 🙂

akreptv

I have the same problem

aaPanel_Jose

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

DendyAndika

i have the same problem..my version 6.2.6

aaPanel_Jose

DendyAndika
Have you tried resetting the mysql root password?

DendyAndika

aaPanel_Jose

thx for your advice..problem solved

guid

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

aaPanel_Jose

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

guid

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

aaPanel_Jose

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

guid

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

aaPanel_Jose

guid
This file is 0 kb?
ls -al /www/server/data/ibdata1

guid

no its

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

aaPanel_Jose

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

guid

aaPanel_Jose yes, how I can give you the login data?

aaPanel_Jose

guid
Please send it to my email zhwyeah@gmail.com

guid

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

STiNG

I have same problem. Pure install on Centos 8 with new installation command. Please help.

aaPanel_Jose

STiNG
What version of mysql are you using?

STiNG

aaPanel_Jose mariadb 10.3

stan0ne

edit /etc/my.cnf and add in config:

[mysqld]
skip-grant-tables

after restart mysql:
service mysqld restart

change password in MySQL maintence:

/www/server/mysql/bin/mysql -u root -p
mysql> flush privileges;
mysql> Set new password by ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';

deewinc

stan0ne edit /etc/my.cnf and add in config:

[mysqld]
skip-grant-tables
after restart mysql:
service mysqld restart

change password in MySQL maintence:
/www/server/mysql/bin/mysql -u root -p
mysql> flush privileges;
mysql> Set new password by ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';

This procedure is partly misleading.

Correct way to do it.

edit /etc/my.cnf via SSH or SFTP
Locate the following line [mysqld]
Add skip-grant-tables directly under [mysqld]
Then restart MySQL using service mysqld restart
Next change password in MySQL maintenance by using the following steps;
==> /www/server/mysql/bin/mysql -u root -p
==> flush privileges;
==> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
Restart MySQL following step 4
`