Author Topic: Cannot managed dababase MySQL from CWP7  (Read 3018 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Cannot managed dababase MySQL from CWP7
« on: March 31, 2022, 08:40:48 AM »
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.

Offline
****
Re: Cannot managed dababase MySQL from CWP7
« Reply #1 on: March 31, 2022, 10:11:17 AM »
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.
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: Cannot managed dababase MySQL from CWP7
« Reply #2 on: March 31, 2022, 10:36:48 AM »
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.

Offline
****
Re: Cannot managed dababase MySQL from CWP7
« Reply #3 on: March 31, 2022, 12:08:10 PM »
Can you verify that the passwords are the same between
/root/.my.cnf   and /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: Cannot managed dababase MySQL from CWP7
« Reply #4 on: April 01, 2022, 02:05:28 AM »
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.

Offline
****
Re: Cannot managed dababase MySQL from CWP7
« Reply #5 on: April 01, 2022, 12:29:12 PM »
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
Google Hangouts:  rcschaff82@gmail.com