problems mysql freebsd 11.2

[d1ncaz0r]

i have a problem with mysql...when i start freebsd is working fine but when i start the server mysql is not running but i connected with navicat perfectly...with this problem when i connect to the server is connected but stuck on connection is running...not start with create caracter.. :|

what problem is this ?

thanks

[xAmnezia.]

Use FreeBSD 11.3

All versions under 11.3 is no longer supported

[d1ncaz0r]

thanks for answer !!
is good 12.1? i install another day 12.1 but i can not finish installation for run server...i install 12.1 mysql57 / 80 but when i change stock mysql folder with mysql from serverfiles mysql cannot running

[Natsu Dragneel]

Originally Posted by d1ncaz0r

thanks for answer !!
is good 12.1? i install another day 12.1 but i can not finish installation for run server...i install 12.1 mysql57 / 80 but when i change stock mysql folder with mysql from serverfiles mysql cannot running

Can you post your error-logs?

[d1ncaz0r]

this is the picture with my problem...



error mysql

[MQTT.]

the most efficient way is to remove mysql57 and install mysql56.
I remembered there are some problems with mysql57.
Also check if you use python2.7 and not python3.

and get freebsd 11.3 instead of freebsd 12.1. to use freebsd 12.1 you need to make changes in the Source itself.

[d1ncaz0r]

Originally Posted by Nguyen.

the most efficient way is to remove mysql57 and install mysql56.
I remembered there are some problems with mysql57.
Also check if you use python2.7 and not python3.

and get freebsd 11.3 instead of freebsd 12.1. to use freebsd 12.1 you need to make changes in the Source itself.

thanks!! one tutorial fast for make mysql finish install and working good ? thanks !!

[MQTT.]

Originally Posted by d1ncaz0r

thanks!! one tutorial fast for make mysql finish install and working good ? thanks !!

use pkg autoremove to remove the mysql57 and python3.7 packages, e.g.

pkg autoremove mysql57

and then install it with the command again, but specify the version, e.g.

pkg install python27

I'm a bit drunk so if anything false, just follow your tutorial with the exception of using the version of package to install rather than only the package name

if you want to update freebsd use
freebsd-update -r 11.2

[ThaRielFliege]

You dont have to do changes in source to get it running on 12.1, just something in extern folder and makefile.
Only when you want to use mysql 8.0, but i cant see a reason why we should do it. (since mysql will never be the bottleneck of M2)

BTT: Use mysql56 and better use sql backups not full mysql packed as tar.gz. Replacing the mysql folder with another folder from another system isnt very good.
If you get problems with starting the mysql-server you could give us the .err file from /var/db/mysql so that we can see why its not starting.