did you ran mysql upgrade command ?
you can manually install mysql by removing mariadb
http://prnt.sc/eolgxk , and may other errors in CWP version: 0.9.8.196 + MySQL 5.7
Hi, Sandeep.. Iīve installed latest cwp on a testing vps on AWS..just to try this..
Of course it installed MariaDB as default..once it finished and rebooted..I went again via ssh..
Then I ran yum remove MariaDb-*
it removed Mariadb server, client, etc from server..ok..
Then I've installed MySql in server.. after it finished, started the service..
after that, I enter "mysql_upgrade --upgrade-system-tables"..
once it finished that, I entered to the mysql console...
typed "SELECT COUNT(1) column_count FROM information_schema.columns WHERE table_schema='mysql' AND table_name='user';"
I know I should have a 43 columns count.. but instead I got, 46.. the "extra" rows are the following...
mysql user is_role 44
mysql user default_role 45
mysql user max_statement_time 46
After seeing that.. I entered to CWP, and saw that pure-ftp has a sort of yellow moon icon..and it didnīt state that service was runnning.. only showed that icon.. so, I followed instructions to reinstall pure-ftpd server.. via ssh... once it finished.. went back to cwp,pure-ftpd has no longer that "moon Icon" and was up and running... so I created a new account, (after created a package of course) set the password for that account...tried to access via FTP... "wrong user or password".. mmm tried again after changing users pass..same story... then I checked mysqld.log.. it showed that /usr/sbin/mysqld: column count of mysql.user is wrong expected 43, found 46 The table is probably corrupted...
So, I've figured that changing MariaDB to MySQL also affected CWP services..
Tried a couple of things.. like, removing mysql server again, reinstall it, then ran mysql upgrade but that didnīt fix the count column number, nor the pure-ftpd... so to make story short...
Although MariaDB was removed, and Mysql server installed in CWP latest version,and it was up and running... I kept having on mysqld.log those warnings mentioned above.. also I was not able to connect to pure-ftpd server with the user and pass of the account I made before.
So, is there a solution for this? in many topics it was suggested here that if we donīt want MariaDB, we can always uninstall it, and install Mysql instead.. though never thought I would have so much trouble with this..
Thanks for the help..