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
1456
August 19, 2021 02:03AM
399
August 19, 2021 11:45AM
435
August 19, 2021 03:00PM
373
August 19, 2021 03:51PM
324
August 19, 2021 05:42PM
322
August 20, 2021 08:00AM
344
August 20, 2021 10:42AM
Re: C++ mySQL connection failed
395
August 20, 2021 11:43AM
503
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.