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
1178
August 19, 2021 02:03AM
312
August 19, 2021 11:45AM
319
August 19, 2021 03:00PM
294
August 19, 2021 03:51PM
250
August 19, 2021 05:42PM
240
August 20, 2021 08:00AM
264
August 20, 2021 10:42AM
Re: C++ mySQL connection failed
299
August 20, 2021 11:43AM
327
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.