[Cialug] MySQL grant issue

L. V. Lammert lvl at omnitec.net
Fri Jul 16 22:16:38 UTC 2021


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!


More information about the Cialug mailing list