How install mysql compatible with php 5.2.17

PTYNETWORK

How install mysqli compatible with php 5.2.17

aaPanel_Kern

PTYNETWORK
Hello, what is your mysql version? Try lowering the mysql version.

PTYNETWORK

My mysql version is 5.6 but when I want to install low version like 5.1 the process starts but uninstall the 5.6 and is not start the 5.1.
I've tied to install mysql 5.1 however the system doesnt install it, mysql 5.5 is installed without issue.

PTYNETWORK

now Ive installed mysql 5.5 but the website shows these issues:

Warning: mysqli_connect(): (HY000/1129): Host '192.168.1.115' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /www/wwwroot/domain/settings/config.php on line 9

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/settings/config.php on line 41

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/settings/config.php on line 42

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/settings/config.php on line 43

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/settings/config.php on line 44

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/index.php on line 18

aaPanel_Kern

PTYNETWORK
Hello, it is recommended that you contact the website program developer, what version of php is required for the program, different parameters of mysql use inconsistent php versions

PTYNETWORK

the version just supported is 5.2 but now is something with 'mysqladmin flush-hosts'

How can I reset or clean the ip blocked on the mysqladmin?

aaPanel_Kern

PTYNETWORK
This is to clear the hosts cache. I suggest you check whether the mysql configuration in /www/wwwroot/domain/settings/config.php is correct?

PTYNETWORK

Yes it is there

aaPanel_Kern

configuration is correct?check

PTYNETWORK

the config is correct Ive test connecting with navicat to the remote mysql.

MySQL version 12.22 distrib 4.0.20 on Red Hat 9

aaPanel_Kern

PTYNETWORK
Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:

No post link will not be able to know which user's information is

PTYNETWORK

sent already thanks.

Please note I have another website working with 7.4 php without issue, just the website that is config with 5.2 is not working and not connecting with the mysql remote, Ive done the snapshot.

aaPanel_Kern

PTYNETWORK
Hello, this is an environmental problem. It is recommended to consult the website program developer what environment is required to run. Also your site is not using mysl5.5 of the panel

PTYNETWORK

I am looking to install another version lower like mysql 5.1 but it cannot be installed.
Why if I've installed mysql 5.1 doesn't appear like installed? () I am using ngnix It shouldn't gives problem.
look now

Warning: mysqli_connect(): Connecting to 3.22, 3.23 & 4.0 is not supported. Server is 4.0.20-standard in /www/wwwroot/domain/settings/config.php on line 9

Warning: mysqli_connect(): (HY000/2054): Connecting to 3.22, 3.23 & 4.0 servers is not supported in /www/wwwroot/domain/settings/config.php on line 9

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/settings/config.php on line 41

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/settings/config.php on line 42

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/settings/config.php on line 43

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/settings/config.php on line 44

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /www/wwwroot/domain/index.php on line 18

PTYNETWORK

after the installation of mysql 5.1 on aapanel this doesnt appear, I check mysql server I have installed it
My question is why if I installed 5.1 Ive got it and doesnt appear that is active any version.
Last metadata expiration check: 3:12:05 ago on Thu 02 Feb 2023 01:34:36 AM GMT.
Available Packages
Name : mysql-server
Version : 8.0.26
Release : 1.module_el8.4.0+915+de215114
Architecture : x86_64
Size : 25 M
Source : mysql-8.0.26-1.module_el8.4.0+915+de215114.src.rpm
Repository : appstream
Summary : The MySQL server and related files
URL : http://www.mysql.com
License : GPLv2 with exceptions and LGPLv2 and BSD
Description : MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
: client/server implementation consisting of a server daemon (mysqld)
: and many different client programs and libraries. This package contains
: the MySQL server and some accompanying files and directories.

aaPanel_Kern

PTYNETWORK
Hello, the panel can only manage the mysql installed on the panel, not the mysql installed using yum.
You need to stop and delete the mysql installed using yum first, otherwise you cannot use the panel to install.
Unable to install Please check the error message during the installation process.

PTYNETWORK

I didnt install any mysql using yum, that issue is provided from the panel.

the mysql that Ive installed is from the panel exactly and doesnt work 5.1 and doesnt show any signal of installation on the panel and was installed.

CentOS Stream release 8
Bit:64 Mem:7762M Core:4 gcc:8.5.0 cmake:3.20.2
Linux 4.18.0-408.el8.x86_64 x86_64
ERROR: mysql 5.1 installation failed.
安装失败，请截图以上报错信息发帖至论坛www.bt.cn/bbs求助
或手机访问以下链接、扫码联系企业微信技术求助

帖子或企业微信注明企业版用户，将获得极速响应技术支持

联系链接:https://work.weixin.qq.com/kfid/kfc9072f0e29a53bd52

|-Successify ---Script execution completed---

PTYNETWORK

Solved, now is working php 5.2.17 with mysql 5.5 without issue.

aaPanel_Kern

Hello, mysql5.1 only supports centos 7.

PTYNETWORK

I will test this later thanks for everything