**Thanks Trumpcard**
type mysql from the c:\mysql\bin directory
mysql>GRANT ALL PRIVILEGES ON eq.* TO someid@localhost
IDENTIFIED BY 'somepass' WITH GRANT OPTION;
or, the less secure but more useful technique that will allow you to log on with that user name from any machine.
GRANT ALL PRIVILEGES ON eq.* TO someid@'someip'
IDENTIFIED BY 'somepass' WITH GRANT OPTION;
Stick with those rather than the % i'll happily admit i know squat about sql but both of those ways have worked for me. It sounds like you're typing something in wrong to get the syntax error response. BTW DO NOT type in the mysql> bit. just GRANT ALL .......... etc etc only go with one or the other of those GRANTS as well.... just in case.
Trig
|