problems mysql freebsd 11.2

05/14/2020 22:57 d1ncaz0r#1

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:handsdown:

05/15/2020 00:10 xAmnezia.#2

Use FreeBSD 11.3

All versions under 11.3 is no longer supported

05/15/2020 01:07 d1ncaz0r#3

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 :(

05/15/2020 13:04 Natsu Dragneel#4

Quote:

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?

05/17/2020 17:42 d1ncaz0r#5

this is the picture with my problem...

[Only registered and activated users can see links. Click Here To Register...]

error mysql

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

05/17/2020 20:35 MQTT.#6

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.

05/18/2020 16:03 d1ncaz0r#7

Quote:

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 ? :D thanks !!

05/24/2020 02:14 MQTT.#8

Quote:

Originally Posted by d1ncaz0r

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

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

Code:

pkg autoremove mysql57

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

Code:

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

05/24/2020 11:59 ThaRielFliege#9

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.