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

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?

aaPanel_Jose 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

Database password is incorrect! Problem

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
`

aaPanel_Jose

STiNG
I tried installing mariadb10.3 on centos8 and then changing the password and everything worked fine. Can i log in to your server and check

deewinc

Hello,

Just made a new aaPanel installation and I'm unable to create databases.

How do I reset password?

This is the error log.

2021-09-13  9:56:00 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2021-09-13 11:25:33 13 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:25:33 14 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:25:33 15 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:25:33 16 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:25:33 17 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:25:33 18 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:27:44 19 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:27:44 20 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:27:44 21 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:27:44 22 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:27:44 23 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:27:44 24 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:28:35 25 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:28:35 26 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:28:35 27 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:28:35 28 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:28:35 29 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:28:35 30 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:29:04 31 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:29:04 32 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:29:04 33 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:29:04 34 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:29:04 35 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:29:04 36 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:37:10 37 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:37:10 38 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:37:10 39 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:37:10 40 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:37:10 41 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2021-09-13 11:37:10 42 [Warning] Access denied for user 'root'@'localhost' (using password: YES)

« Previous Page