Install mysql56-server on any FreeBSD _i386 /x64

[elpatron]

Sometimes there is a need to use older software because there are compatibility problems with the current one. Often such a case in the metin2 server is a mysql server where there are differences between versions of mysql /mariadb and releases /5.6 /8.0. To avoid this hassle there is a way to install mysql56-server mysql56-client on any release of Freebsd up to 14 x64.

To do this just do the following:
1. download the files
[Hidden content]
put in sftp ftp to ur server and follow 2. 3. 4. step

2. install mysql56

pkg install mysql56-client-5.6.51.pkg mysql56-server-5.6.51.pkg

3. check if the library files are already installed

find / -iname "libssl.so.111" && find / -iname "libcrypto.so.111"

this command should this result as they are installed

/usr/lib/libssl.so.111
/lib/libcrypto.so.111

If it shows nothing means that we have to install them manually

tar -xzf libs_64bit_mysql.tgz -C /

(for Freebsd 32bit use libs_32bit_mysql.tgz )

3.now we have mysql56 installed and proceed as standard

sysrc mysql_enable=YES
service mysql-server start
mysql_secure_installation

The rest is done exactly the same as with any other mysql server, then just add the user and install the databases.

 

[sunnyxtc]

thanks a lot !

 

[elpatron]

Sometimes there is a need to use older software because there are compatibility problems with the current one. Often such a case in the metin2 server is a mysql server where there are differences between versions of mysql /mariadb and releases /5.6 /8.0. To avoid this hassle there is a way to install mysql56-server mysql56-client on any release of Freebsd up to 14 x64.

To do this just do the following:
1. download the files
[Hidden content]
put in sftp ftp to ur server and follow 2. 3. 4. step

2. install mysql56

pkg install mysql56-client-5.6.51.pkg mysql56-server-5.6.51.pkg

3. check if the library files are already installed

find / -iname "libssl.so.111" && find / -iname "libcrypto.so.111"

this command should this result as they are installed

/usr/lib/libssl.so.111
/lib/libcrypto.so.111

If it shows nothing means that we have to install them manually

tar -xzf libs_64bit_mysql.tgz -C /

(for Freebsd 32bit use libs_32bit_mysql.tgz )

3.now we have mysql56 installed and proceed as standard

sysrc mysql_enable=YES
service mysql-server start
mysql_secure_installation

The rest is done exactly the same as with any other mysql server, then just add the user and install the databases.

 

[elyzeu]

Às vezes, há a necessidade de usar software mais antigo porque há problemas de compatibilidade com o atual. Muitas vezes tal caso no servidor metin2 é um servidor mysql onde há diferenças entre as versões do mysql /mariadb e as versões /5.6 /8.0. Para evitar esse incômodo, há uma maneira de instalar o mysql56-server mysql56-client em qualquer versão do Freebsd até 14 x64.

Para fazer isso, basta fazer o seguinte:
1. Faça o download dos arquivos
[Conteúdo oculto]
Coloque em FTP FTP para o seu servidor e siga 2. 3. 4. passo

2. Instale o MySQL56

[CÓDIGO]pkg instalar mysql56-client-5.6.51.pkg mysql56-server-5.6.51.pkg[/CODE]
3. Verifique se os arquivos da biblioteca já estão instalados

find / -iname "libssl.so.111" && find / -iname "libcrypto.so.111"

este comando deve este resultado como eles são instalados

[CÓDIGO]/usr/lib/libssl.so.111
/lib/libcrypto.so.111[/CÓDIGO]
Se não mostrar nada significa que temos que instalá-los manualmente

[CÓDIGO]tar -xzf libs_64bit_mysql.tgz -C /[/CÓDIGO]
(para Freebsd 32bit use libs_32bit_mysql.tgz)

3.Now temos MySQL56 instalado e prosseguir como padrão

[CÓDIGO]sysrc mysql_enable=SIM
serviço mysql-server start
mysql_secure_installation[/CÓDIGO]
O resto é feito exatamente como com qualquer outro servidor mysql, então basta adicionar o usuário e instalar os bancos de dados.

Ty

 

[paulosilva1996]

Sometimes there is a need to use older software because there are compatibility problems with the current one. Often such a case in the metin2 server is a mysql server where there are differences between versions of mysql /mariadb and releases /5.6 /8.0. To avoid this hassle there is a way to install mysql56-server mysql56-client on any release of Freebsd up to 14 x64.

To do this just do the following:
1. download the files
[Hidden content]
put in sftp ftp to ur server and follow 2. 3. 4. step

2. install mysql56

pkg install mysql56-client-5.6.51.pkg mysql56-server-5.6.51.pkg

3. check if the library files are already installed

find / -iname "libssl.so.111" && find / -iname "libcrypto.so.111"

this command should this result as they are installed

/usr/lib/libssl.so.111
/lib/libcrypto.so.111

If it shows nothing means that we have to install them manually

tar -xzf libs_64bit_mysql.tgz -C /

(for Freebsd 32bit use libs_32bit_mysql.tgz )

3.now we have mysql56 installed and proceed as standard

sysrc mysql_enable=YES
service mysql-server start
mysql_secure_installation

The rest is done exactly the same as with any other mysql server, then just add the user and install the databases.

thanks