Author Topic: FRESH INSTALL :: Could not select database root_cwp  (Read 983 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
FRESH INSTALL :: Could not select database root_cwp
« on: February 08, 2020, 01:10:13 AM »
Hi! I just installed CWP on CentOS 7 (Minimal) fresh installation was made.

Application Version:
Code: [Select]
Apache version: Apache/2.4.39
PHP version: 7.3.14
MySQL version: 10.1.44-MariaDB
FTP version: 1.0.47
SSH Port: 2225
MySql Port: 3306
Web Servers: apache-only

System Server Info:
Code: [Select]
CPU Model: Intel(R) Xeon(R) CPU E5-1660 v3 @ 3.00GHz
CPU Details: 2 Core (3000 MHz)
Distro Name: CentOS Linux release 7.7.1908 (Core)
Kernel Version: 3.10.0-1062.12.1.el7.x86_64
Platform: x86_64

I am getting error "Could not select database root_cwp" when restarting "MySQL Database Server"

Any idea on how to solve this.?


Thank you.

Offline
***
Re: FRESH INSTALL :: Could not select database root_cwp
« Reply #1 on: February 08, 2020, 01:36:16 AM »
find the password in /root/.my.cnf  ( cat /root/.my.conf )   
curl -s http://centos-webpanel.com/webpanel/main.php?app=showip

Record these two things  ^^^^^


wget http://static.cdn-cwp.com/files/cwp/sql/root_cwp.sql
wget http://static.cdn-cwp.com/files/cwp/sql/oauthv2.sql
mysql -u root -p << root_cwp.sql
mysql -u root -p << oauthv2.sql

now manually
mysql -uroot -p  ( At the Maria DB command line now)
use root_cwp;
UPDATE settings SET shared_ip="IP FROM EARLIER";
exit
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: FRESH INSTALL :: Could not select database root_cwp
« Reply #2 on: February 08, 2020, 04:02:23 AM »
This one helps rcschaff! Thank a lot and now working.
find the password in /root/.my.cnf  ( cat /root/.my.conf )   
curl -s http://centos-webpanel.com/webpanel/main.php?app=showip

Record these two things  ^^^^^


wget http://static.cdn-cwp.com/files/cwp/sql/root_cwp.sql
wget http://static.cdn-cwp.com/files/cwp/sql/oauthv2.sql
mysql -u root -p << root_cwp.sql
mysql -u root -p << oauthv2.sql

now manually
mysql -uroot -p  ( At the Maria DB command line now)
use root_cwp;
UPDATE settings SET shared_ip="IP FROM EARLIER";
exit