MySQL Forums
Forum List  »  Connector/C++

Re: C++ mySQL connection failed
Posted by: Peter Brawley
Date: August 20, 2021 11:43AM

Oh dear, you've somehow made a mess in mysql.user.

At step 5 When you execute the reset-root sequence...

select user,host,authentication_string from mysql.user;

... you will need to ...

(i) set authentication_plugin to mysql_native_password for all users

(ii) delete all but one of those mysql.user rows where user='root', for the one remaining set host='localhost' with your desired password and authentication_plugin value, then set up another user, not root , for access through apps like yours.

Options: ReplyQuote


Subject
Views
Written By
Posted
251
August 19, 2021 11:45AM
241
August 19, 2021 03:00PM
229
August 19, 2021 03:51PM
207
August 19, 2021 05:42PM
198
August 20, 2021 08:00AM
192
August 20, 2021 10:42AM
Re: C++ mySQL connection failed
241
August 20, 2021 11:43AM
229
August 20, 2021 01:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.