phpmyadmin access denied!

arsse

Hello.
I can not access phpmyadmin.
webserver is ols.
`
Welcome to phpMyAdmin

Error

MySQL said: Documentation
Cannot connect: invalid settings.
mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.`

arsse

I edited phpmyadmin config file and add mysql root password and now it work.
But a problem:
after mysql root password is changed from aapanel>database section, when we uninstall and again reinstall phpmyadmin, it use old password for phpmyadmin!!

aaPanel_Jose

arsse
but reinstalling phpmyadmin will not affect the mysql password

mysql and phpmyadmin are two independent applications.

arsse

aaPanel_Jose but reinstalling phpmyadmin will not affect the mysql password

mysql and phpmyadmin are two independent applications.

Thanks for help.
so, if we change mysql root password from panel then it not automatically change password of access to db in phpmyadmin config file.

aaPanel_Jose

arsse
If you change the mysql root password from the panel. phpmyadmin will follow the changes.

Could you tell me what is the version of the panel you are using?

arsse

aaPanel_Jose

Thanks.
Latest version.
Last day after panel update i saw this problem but now i saw it is automatic and php my admin open inside panel without needing any user and pass for using it.
Thanks for a such good panel.

arsse

Hello.
Please Help me.
You made panel that when we click on databases>phpmyadmin button it automatically open phpmyadmin without needing insert username/passwords.
Today after i clicked on phpmyadmin button it requested user/pass also it not be SSL!
Please help about this problem.
Thanks

arsse

...also it can not make backup by cliking backup button!
Please help There are sevral problem in mysql.

aaPanel_Jose

arsse
Does an error message pop up when I click the backup button?

arsse

aaPanel_Jose
Hello Jose.
Thanks for answering this request.
No. backup problem solved automatically!
problem is previous post:

You made panel that when we click on databases>phpmyadmin button it automatically open phpmyadmin without needing insert username/passwords.
Today after i clicked on phpmyadmin button it requested user/pass also it not be SSL!

aaPanel_Jose

arsse
Please try to reinstall and setup ssl phpmyadmin

arsse

aaPanel_Jose Please try to reinstall and setup ssl phpmyadmin

I tried to set port for ssl and enable ssl in panel dialog box but it said could not because it is OLS web server.
I remember it was auto login with ssl on OLS even phpmyadmin dialog box was disabled SSL.

arsse

Today i changed mysql root password from panel and after that it could not create backup from panel and after restarting mysql can not start.
All my site is down.
Please help.
Thanks

arsse

2020-11-07 15:38:21 47254201338304 [Note] Found 1 prepared transaction(s) in InnoDB
2020-11-07 15:38:21 47254201338304 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
2020-11-07 15:38:21 47254201338304 [ERROR] Aborting

arsse

arsse 2020-11-07 15:38:21 47254201338304 [Note] Found 1 prepared transaction(s) in InnoDB
2020-11-07 15:38:21 47254201338304 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
2020-11-07 15:38:21 47254201338304 [ERROR] Aborting

Hi
What command must i do in terminal for solving this problem?
Please help.

arsse

Hello.
Why nobody help me?

tongduc315

arsse disabled force SSL