Control Web Panel

WebPanel => MySQL => Topic started by: Jayster on February 08, 2020, 01:10:13 AM

Title: FRESH INSTALL :: Could not select database root_cwp
Post by: Jayster 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.
Title: Re: FRESH INSTALL :: Could not select database root_cwp
Post by: rcschaff 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
Title: Re: FRESH INSTALL :: Could not select database root_cwp
Post by: Jayster 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