Command line question MySQL

[warlockz]

GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

I'm no programmer by any sort, I'm mearly curious if I can host my own server, and try and teach myself how to manipulate it. perhaps I may even get good at it, novice by your standards i'm sure but can't hurt to try,

my question is where should the username and pass work for the command line be put, I saw a post on it but I can't seem to locate it so I can enter the command line correctly,

post an example of this command line if you would so I can better understand what the command line needs to work correctly

thanks

[koad]

your posted example

GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

gives access to all dbs, to all users (that mysql recognizes) with any username and password (% is wildcard)

When your changing db privledges you need to be in the client as root (even in windoze). In windows you will login as root if the mysqladmin is running, just do the following:

mysql -u root mysql

then you can change your db privledges for the user that your server/editors use to login as. i used:

grant all privileges on eq.* to 'eqemu'@localhost identified by 'test' with grant option;

so my servers login to the database called eq with the user/pass (eqemu/test) thats in c:\winnt\my.ini file (editable right in mysqladmin)