Grants from host % vs localhost

Hi I googled if I needed a separate user with grants from localhost even if % was already created. Posts from 10 years ago said yes as localhost used a different socket. Is this still the case?

I prefer to keep mysql.user as uncluttered as possible.

Thanks! Sorry if this has been asked before.

Answer Answered by Ian Gilfillan in this comment.

Separate users are not needed. Note however that some setups create anonymous users, which can cause failures to log in as expected from localhost. See Troubleshooting Connection Issues#localhost and %


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.