MySQL Forums
Forum List  »  Newbie

Re: MySQL Error Number 2003
Posted by: Peter Brawley
Date: August 17, 2022 10:08AM

> | root | localhost | caching_sha2_password |

`root` user is authorised to login only locally.

It's insecure but the simplest solution is to change root's host to %. After such changes, issue Flush Privileges.

More secure is to define a netadmin user with the minimum privileges for that user.

Options: ReplyQuote

Written By
August 16, 2022 03:14AM
August 16, 2022 03:16AM
August 16, 2022 10:27AM
August 16, 2022 09:07PM
August 16, 2022 09:29PM
August 16, 2022 10:33PM
August 16, 2022 10:37PM
Re: MySQL Error Number 2003
August 17, 2022 10:08AM
August 18, 2022 01:13AM
August 18, 2022 10:02PM

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.