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


Subject
Written By
Posted
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.