OnlyRipper 56 Posted June 20, 2019 Share Posted June 20, 2019 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? Link to comment Share on other sites More sharing options...
OnlyRipper 56 Posted June 21, 2019 Author Share Posted June 21, 2019 Problem solved.Please remove the topic.Thanks! Link to comment Share on other sites More sharing options...
NoobMaster1337 7 Posted June 21, 2019 Share Posted June 21, 2019 vor 5 Stunden schrieb OnlyRipper: Problem solved.Please remove the topic.Thanks! A solution would be nice. Link to comment Share on other sites More sharing options...
OnlyRipper 56 Posted June 21, 2019 Author Share Posted June 21, 2019 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. Link to comment Share on other sites More sharing options...
Shahin 223 Posted April 11, 2020 Share Posted April 11, 2020 (edited) 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 Link to comment Share on other sites More sharing options...
scrabbyyy 20 Posted May 18, 2020 Share Posted May 18, 2020 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 Link to comment Share on other sites More sharing options...
Premium WeedHex 635 Posted May 18, 2020 Premium Share Posted May 18, 2020 33060 127.0.0.1.3306 Link to comment Share on other sites More sharing options...
scrabbyyy 20 Posted May 18, 2020 Share Posted May 18, 2020 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 Link to comment Share on other sites More sharing options...
sharqawy 0 Posted September 19, 2023 Share Posted September 19, 2023 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 Link to comment Share on other sites More sharing options...
Premium Intel 760 Posted September 21, 2023 Premium Share Posted September 21, 2023 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now