[Cialug] MySQL grant issue

[Andrew Denner]

If I remember correctly there is an ini file located in  C:\Program
Files\MySQL\MySQL Server x.x\my.ini that you need to comment out the bind
address line.

You also may need to reset the password for remote root.

update user set authentication_string=password('YOUR_PASSWORD') where
user='remoteroot';
flush privileges;

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
>