CWP CentOS 7 installer with MySQL without MariaDB

[erntesky]

Can somebody know how to install CWP on CentOS 7 with MySQL without MariaDB?

The following command line working if somebody want mariadb:

Code Select Expand

cd /usr/local/src
wget wget http://centos-webpanel.com/cwp-el7-latest
sh cwp-el7-latest -d mariadb

But is not working with "mysql" or the right name is "mysqld"?

[robbyq]

Can somebody know how to install CWP on CentOS 7 with MySQL without MariaDB?

The following command line working if somebody want mariadb:

Code Select Expand

cd /usr/local/src
wget wget http://centos-webpanel.com/cwp-el7-latest
sh cwp-el7-latest -d mariadb

But is not working with "mysql" or the right name is "mysqld"?

what u said?

automatic install mysql and not maria db?

[Administrator]

mariadb is now default in centos 7 so mysql is not installed, you would need to install mysql manually if you want it....but what would be the reason for that ?

[erntesky]

The MariaDB will be in the next few years be a similar situation such as MySQL yet now and then have to move (change) again to another? I use it for about 10 years and I insist on using MySQL. (Besides, why do not think about those who are MySQL subscribers? In addition, a very serious and global database we speak. I am seriously not happy with MariaDB. (Especially that the MySQL v5.7 and MySQL v8.0 is not compatible with MariaDB.)

It is possible please to make a switch (-d mysql) what install the MySQL and not the MariaDB?

If this is not possible, how is possible the total removal of MariaDB?

[Administrator]

you can export all databases and then remove what you don't want and install any database you want

[erntesky]

Is so not easy...

The following command uninstall the MariaDB, but made conflicts with MySQL installer:

Code Select Expand

yum remove MariaDB MariaDB-server

This command totaly delete the MariaDB but straight killed the server: (Removed other important thinks as well...)

Code Select Expand

yum remove MariaDB MariaDB-server MariaDB-common MariaDB-shared

How I have to uninstall properly / totally MariaDB?

[Administrator]

backup databases and users and then remove mariadb, after that install mysql ver you want and import databases again.

[fredo]

i´m sorry, but where are these users and databases located? i've tryed :
yum remove MariaDB MariaDB-server

then tryed to install mysql but it installed again mariadb.. is there a tutorial or something?
really need cwp w mysql..

please help!

[locvfx]

OMG I'm facing this problemtoo ! How come you guys drop support MySQL and replace it by MariaDB ! this is wrong move though.
All my database is in MySQL version 5.7 and it's not easy to convert to MariaDB !

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json DEFAULT NULL,

I removed Mariadb, installed MySQL 5.7, and got many weird errors in CWP (on browser)

http://prnt.sc/eolgxk

[fredo]

OMG I'm facing this problemtoo ! How come you guys drop support MySQL and replace it by MariaDB ! this is wrong move though.
All my database is in MySQL version 5.7 and it's not easy to convert to MariaDB !

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json DEFAULT NULL,

I removed Mariadb, installed MySQL 5.7, and got many weird errors in CWP (on browser)

http://prnt.sc/eolgxk

Hi locvfx,
where you able to fix it? where u able to install cwp on centos 7 with mysql 5.6 o 5.7?
cheers

[locvfx]

No, you should not remove Mariadb, you will get many errors in web panel.

[weasam]

mariadb is now default in centos 7 so mysql is not installed, you would need to install mysql manually if you want it....but what would be the reason for that ?

the reason for that is some application would have SQLsyntax error IN MY CASE IS NEED TO INSTALL ATROPIM

[2022-05-31 03:06:11] Log.ERROR: PDO Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. For query 'INSERT INTO locale (id, name, language, date_format, time_zone, week_start, time_format, thousand_separator, decimal_mark) VALUES ('1', 'Main', 'en_US', 'DD.MM.YYYY', 'UTC', 'monday', 'HH:mm', '.', ',')' [] []
[2022-05-31 03:08:51] Log.ERROR: API [GET]:/api/v1/Settings, Params:Array ( ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_es_es' in 'field list' [] []
[2022-05-31 03:08:51] Log.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_es_es' in 'field list', Code: 42S22 URL: /api/v1/Settings [] []

[rcschaff]

CWP requires MariaDB.  You could however install MySQL in a docker or lxc enviroment.