[Cialug] MySQL grant issue

[Dave Hala]

If your mysql server and mysqlclient are a couple of versions apart there
is the possibility that they are using a different password hash.

Also, on older versions of mysql servers you need to remember to  run
"flush privileges" after you change permissions.




On Fri, Jul 16, 2021 at 5:17 PM L. V. Lammert <lvl at omnitec.net> wrote:

> Hitting a prod MySQL on a Win32 box, .. even with a user granted
> access from '%':
>
> Grants for remoteroot@% :
>
>  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,
> PROCESS, FILE, REFERENCES, INDEX. . . .
>
>  best I can get is access denied:
>
> ERROR 1045 (28000): Access denied for user 'remoteroot'@'10.1.2.9' (using
> password: YES)
>
> Anyone the trick to allowing remote users on a Win32 box? There does not
> appear to be a .cnf file on the system, ..
>
>         Thanks!
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> https://www.cialug.org/cgi-bin/mailman/listinfo/cialug
>


-- 
NIFCAP  -The Premier Client Intake System for Non-Profit Organizations.
https://www.osis.us