FreeBSD 12 & MySQL 8

[OnlyRipper 53]

I've tryed to start the server using FreeBSD 12 and MySQL8 .

The problem is that the mysql client isn't compatible.

I've installed mysql8 using ports and using pks.I've tried both ways to see if there's a problem with these methods.None of them could make the connection OK.

Right now from what i've read the MySQL Client Update proccess is part of the MySQL Server.

I updated my ports,my pks,my whatever it's needed to make sure the client is compatible.

Right now they are both: mysql80-server & mysql80-client.

Someone knows or faces this problem before?

[OnlyRipper 53]

Problem solved.Please remove the topic.Thanks!

[NoobMaster1337 7]

vor 5 Stunden schrieb OnlyRipper:

Problem solved.Please remove the topic.Thanks!

A solution would be nice.

[OnlyRipper 53]

I've reinstalled mysql80 throught ports.
Regarding the error I've encountered,in mysql8 you have to create a new user and give him the neccesary permission.

 

After connecting to your mysql with root user follow these commands:

CREATE USER 'foo'@'$' IDENTIFIED WITH mysql_native_password BY 'YourPassword';

CREATE USER 'foo'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPassword';

GRANT ALL PRIVILEGES ON *.* TO'foo'@'localhost';

GRANT ALL PRIVILEGES ON *.* TO'foo'@'%';

FLUSH PRIVILEGES;

 

 

This allowed me to enter and indeed use the database through navicat.The problem was always the connection.I wasn't allowed to join even if it was root.
I've done what i've said upper and it worked.

I hope it will help you.Keep in mind that mysql8 uses different syntax.

(update set ..... now it's with ALTER USER etc.)

If you have any further questions feel free to ask.

[Shahin 213]

On 6/22/2019 at 12:39 AM, OnlyRipper said:

I've reinstalled mysql80 throught ports.
Regarding the error I've encountered,in mysql8 you have to create a new user and give him the neccesary permission.

 

After connecting to your mysql with root user follow these commands:

CREATE USER 'foo'@'$' IDENTIFIED WITH mysql_native_password BY 'YourPassword';

CREATE USER 'foo'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPassword';

GRANT ALL PRIVILEGES ON *.* TO'foo'@'localhost';

GRANT ALL PRIVILEGES ON *.* TO'foo'@'%';

FLUSH PRIVILEGES;

 

 

This allowed me to enter and indeed use the database through navicat.The problem was always the connection.I wasn't allowed to join even if it was root.
I've done what i've said upper and it worked.

I hope it will help you.Keep in mind that mysql8 uses different syntax.

(update set ..... now it's with ALTER USER etc.)

If you have any further questions feel free to ask.

are you still available to help out ?

i have a problem, not letting me use the grant priviledges on the @'%' .. 

I cannot connect to navicat for some reason.. i don't know what to do.

i have it started on my virtual machine, but on mysql 5.6 with no problems

 

Quote

# netstat -an -f inet | grep \.3306
tcp46      0      0 *.33060                *.*                    LISTEN
tcp4       0      0 127.0.0.1.3306         *.*                    LISTEN
#
 

Edited August 25, 2022 by Metin2 Dev
Core X - External 2 Internal

[scrabbyyy 20]

On 6/22/2019 at 12:39 AM, OnlyRipper said:

I've reinstalled mysql80 throught ports.
Regarding the error I've encountered,in mysql8 you have to create a new user and give him the neccesary permission.

 

After connecting to your mysql with root user follow these commands:

CREATE USER 'foo'@'$' IDENTIFIED WITH mysql_native_password BY 'YourPassword';

CREATE USER 'foo'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPassword';

GRANT ALL PRIVILEGES ON *.* TO'foo'@'localhost';

GRANT ALL PRIVILEGES ON *.* TO'foo'@'%';

FLUSH PRIVILEGES;

 

 

This allowed me to enter and indeed use the database through navicat.The problem was always the connection.I wasn't allowed to join even if it was root.
I've done what i've said upper and it worked.

I hope it will help you.Keep in mind that mysql8 uses different syntax.

(update set ..... now it's with ALTER USER etc.)

If you have any further questions feel free to ask.

i have same problem please help me

[WeedHex 626]

33060

127.0.0.1.3306

 

 

[scrabbyyy 20]

4 minutes ago, WeedHex said:

33060

127.0.0.1.3306

 

 

yes friend i did this you talking about this command sysrc mysql_args="--bind-address=127.0.0.1"

 

but not worked for me can u come with teamviewer please 

[sharqawy 0]

to solve Protocol mismatch problem you need to change your my.cnf file, change bind-address from : 127.0.0.1

to 0.0.0.0 to allow connections this is how I solved it, just in case anyone facing this problem anytime

[Intel 731]

On 9/19/2023 at 6:48 PM, sharqawy said:

to solve Protocol mismatch problem you need to change your my.cnf file, change bind-address from : 127.0.0.1

to 0.0.0.0 to allow connections this is how I solved it, just in case anyone facing this problem anytime

That's weird, I also use MySQL 8.0 (only database, not actual linking, though it shouldn't matter) and:
 

[mysqld]
user                            = mysql
port                            = 3306
socket                          = /tmp/mysql.sock
bind-address                    = 127.0.0.1