Control Web Panel
WebPanel => MySQL => Topic started by: erntesky on March 07, 2017, 04:52:30 PM
-
Can somebody know how to install CWP on CentOS 7 with MySQL without MariaDB?
The following command line working if somebody want mariadb:
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"?
-
Can somebody know how to install CWP on CentOS 7 with MySQL without MariaDB?
The following command line working if somebody want mariadb:
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?
-
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 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?
-
you can export all databases and then remove what you don't want and install any database you want
-
Is so not easy...
The following command uninstall the MariaDB, but made conflicts with MySQL installer:
yum remove MariaDB MariaDB-server
This command totaly delete the MariaDB but straight killed the server: (Removed other important thinks as well...)
yum remove MariaDB MariaDB-server MariaDB-common MariaDB-shared
How I have to uninstall properly / totally MariaDB?
-
backup databases and users and then remove mariadb, after that install mysql ver you want and import databases again.
-
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!
-
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
-
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
-
No, you should not remove Mariadb, you will get many errors in web panel.
-
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 [] []
-
CWP requires MariaDB. You could however install MySQL in a docker or lxc enviroment.