Install mysql56-server on any FreeBSD _i386 /x64

[gargamelt 360]

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 

This is the hidden content, please

• Sign In
• or
• Sign Up

This is the hidden content, please

• Sign In
• or
• Sign Up

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 /

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.

[CjMt2 28]

Thanks for the post, it's useful though

 

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

it should be

 

pkg install -y mysql56-client mysql56-server

 

[porexemplo 20]

That is until 13x, im using 14.0

FreeBSD Srcs64 14.0-RELEASE FreeBSD 14.0-RELEASE #0 releng/14.0-n265380-f9716eee8ab4: Fri Nov 10 05:57:23 UTC 2023     [email protected]:/usr/obj/usr/src/amd64.amd64/sys/GENERIC amd64


The solution ends on

pkg add -f mysql56-server-5.6.51.pkg

this command forces the installation, just be sure its x64.

[Thunder9355 0]

2nd downloadlink is offline, can we get another link?

 

[Shogun 5203]

There isn't any "need" to run software that was EOLed over ten years ago, let alone MySQL where there are at least three major forks (MySQL, MariaDB and Percona) all of which went out of their way to maintain backwards compatibility. That's about in the same level of incompetence as doing chmod 777 /.

The most compatible in my experience is MariaDB 10.6.

What you need to know about MariaDB 10.6 is once you install it you do "service mysql-server onestart" and it will install the system tables. You can then just type "mysql" in SSH as it will create a socket user for root that needs no password, and then create a mysql user for navicat like:

create user admin@localhost identified by 'mypassword' with grant option;

grant all on *.* to admin@localhost;

Then just use navicat (SSH Tunnel option!) to easily do the rest.

Then edit /usr/local/etc/mysql/conf.d/server.conf and add:

sql_mode = ""

This willl disable all the restrictions in modern versions of MySQL that cause trouble with 5.6, except one: ENUM fields cannot be empty.

So if you have an ENUM field in a table, edit it and make the first item in the ENUM an empty string. 

That's all. Ah, and if you use sockets, the path is not /tmp/mysql.sock but /var/run/mysql/mysql.sock

And NEVER copy the files directly. Export your database:

mysqldump somedatabase > somedatabase.sql

or:

mysqldump -uroot  -p somedatabase > somedatabase.sql *

Copy the resulting sql file(s) to the destination and:

mysql
mysql> create database whatever;
mysql> exit
mysql whatever < whatever.sql

This will prevent your data from becoming corrupted due to differences between versions, and many other problems.
Ah, and do not export / import the "mysql" database itself. It is different between versions. Just recreate your users with the help of navicat.

* A nifty trick, valid for every version, so you never need to enter a user and password for MySQL in the console:

 https://easyengine.io/tutorials/mysql/mycnf-preference/ 

[w4sl 1]

@ Shogun 
You need the mysql56 files to even compile src.

First error when trying to compile:

gmake: *** No rule to make target '/usr/local/include/mysql/typelib.h', needed by 'OBJDIR/BattleArena.o'.  Stop.

typelib.h was in mysql56 and was removed in newer versions. Mariadb also doesn't contain this file, there will probably be more compatibility issues during compilation.

[kamil2321 13]

DUDE!!!! This is my guide!! I wrote it on January 30th on one of the forums, of course I also wanted to post it here but I didn't have time. Please delete this topic or block it, an alternative topic with updated BSD15 (I will also update the ports in some time) is available on another forum. I do not advertise the forum, don't worry, but whatever, these are my packages, he posted them packed on January 30th at 11:30 PM in folders. I got really angry because it's my work, not his. If you don't believe me, use the package scans on virustotal, there will be an exact date for comparison with the forum where I posted the packages.

IMPORTANT!!
if you want search tutorial, search in google:

kamil2321 mysql56

I have unique nickname worldwide.

 

Edited May 30 by kamil2321