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
1284
August 19, 2021 02:03AM
346
August 19, 2021 11:45AM
372
August 19, 2021 03:00PM
323
August 19, 2021 03:51PM
281
August 19, 2021 05:42PM
278
August 20, 2021 08:00AM
299
August 20, 2021 10:42AM
Re: C++ mySQL connection failed
339
August 20, 2021 11:43AM
403
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.