Control Web Panel
WebPanel => MySQL => Topic started 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:
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:
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.
-
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
-
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