Re: C++ mySQL connection failed

[Peter Brawley]

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.