Author Topic: mysql root password error  (Read 190 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
mysql root password error
« on: November 01, 2018, 01:58:43 PM »
Hi CWP Forum,

I'm currently facing issue, I can't access my CWP Panel, it's giving me error:

Code: [Select]
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

I tried and followed everything http://forum.centos-webpanel.com/how-to/how-to-check-my-current-mysql-root-password/

but still my issues are not resolved, please help me someone...

Thanks in advance

Offline
***
Re: mysql root password error
« Reply #1 on: November 01, 2018, 02:10:02 PM »
Above method is old and will not work.

Perform this command from shell and your issue will be resolved

Code: [Select]
/scripts/mysql_pwd_reset
Note:- Don't forget to save new MySQL root password for future use.

Offline
*
Re: mysql root password error
« Reply #2 on: November 01, 2018, 02:43:37 PM »
Above method is old and will not work.

Perform this command from shell and your issue will be resolved

Code: [Select]
/scripts/mysql_pwd_reset
Note:- Don't forget to save new MySQL root password for future use.

Hi Sir,

I tried with the method you gave to me, but still the problem is not solved, I'm getting same issue again..

Please help Sir

Offline
*
Re: mysql root password error
« Reply #3 on: November 01, 2018, 02:57:41 PM »
Hi Sir,

Actually it works when I run command `/scripts/mysql_pwd_reset` ...

And while the command is running and performing its task, I can access my CWP Dashboard and everything..

And when the command completes its action and prints the mysql new password, I'm again getting the same issue on my server.

I'm stuck here, as I'm not expert with CWP, I also tried changing it manually at:

Code: [Select]
/root/.my.cnf
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php

But, again the issue is not resolved, please help me with this..

I'm using latest CWP on CentOS 7, installed it recently 4 days back...

Thanks in advance
« Last Edit: November 01, 2018, 02:59:51 PM by myselfsufian »

Offline
*
Re: mysql root password error
« Reply #4 on: November 02, 2018, 08:14:06 AM »
Should I have to upgrade to CWP Pro..?

Actually I'm planning.. to TEST drive first time the PRO version..

But it would be great If someone help me solve this issue currently I'm facing, it's still not resolve..

It would be great, If I'll get some guide's and suggestion...

Thanks in advance

Offline
*
Re: mysql root password error
« Reply #5 on: November 02, 2018, 07:43:31 PM »
Your passwords in
 /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
 and
 /root/.my.cnf

are equal..??