Cannot managed dababase MySQL from CWP7

[kelvinnguyen]

Hi everyone,

I have just changed password root of MySql DB. Then, I cannot managed dababase from CWP (list, create, ...). At mysql_manager module, have a notify "Attention! An error occurred when listing databases."  and no database, user be listed. (As image https://prnt.sc/sy0iAcekR1NR)

Please help me how to fix this problem.

Thanks so much.

[rcschaff]

Did you change the password using the script  /scripts/mysql_pwd_reset?

If not, you need to run it to change the password again. 

Otherwise please advise that you did use the script, and we will have to troubleshoot further.

[kelvinnguyen]

Did you change the password using the script  /scripts/mysql_pwd_reset?

If not, you need to run it to change the password again. 

Otherwise please advise that you did use the script, and we will have to troubleshoot further.

Thanks for your reply.

Exactly, I changed password using /scripts/mysql_pwd_reset. After that, I cannot manage db from CWP as above post.

Pls show me how to fix it.

Thanks you.

[rcschaff]

Can you verify that the passwords are the same between
/root/.my.cnf   and /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php

[kelvinnguyen]

Can you verify that the passwords are the same between
/root/.my.cnf   and /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php

Hi rcschaff,

I checked it, passwords are the same.

I think that maybe module mysql_manager don't update new password, so CWP cannot connect to mysql.

Thanks rcschaff.

[rcschaff]

Doing a search, that is the only place where the password is set.  Have you tried restarting cwpsrv and cwpphp?

/scripts/restart_cwpsrv

Other than that, It would have to be a permission issue with mariadb's access