Author Topic: Change MySQL Password CRASHES CWP  (Read 6878 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Change MySQL Password CRASHES CWP
« on: August 14, 2018, 04:38:12 AM »
Changing MYSQL password causes CWP Crash
=========================================
Running CWP version: 0.9.8.74  on  Digital Ocean Droplet (1G Memory 25G Storage)
Centos OS  7.5 x64 installed
Changing MYSQL password causes CWP Crash
=====================================================================
Install CWP from  http://centos-webpanel.com/cwp-el-latest
Log on using root

From Dashboard
Select MySQL Manager
Select List Users
Select root[P]  - Change password
Change password for MySQL User root
Save
System Crashes

============================================================
UPDATE mysql.User SET PASSWORD = PASSWORD('not4youTEST') WHERE user = "root"
============================== SHOWS ==========================================


Data Entered
================================
Username: root [localhost]
New Password: WillCr4sh

Username root with host localhost not found in mysql.user table!
============================== THEN ==========================================

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
============================== SYSTEM HANGS ==========================================

When Trying to repost BUG got
==========================================

Forbidden
You don't have permission to access /bug_report.php on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

Offline
*****
Re: Change MySQL Password CRASHES CWP
« Reply #1 on: August 14, 2018, 12:13:43 PM »
You can also deal with this

Code: [Select]
sh /scripts/mysql_pwd_reset