[ale] MySql: How do I grant all priviledes to a remote user

[George Carless]

> > I've created a user/password pair and can login, but how do I give
> > that user full privileges?
> > 
> > Specifically, I want to have the ability to create databases, tables,
> > fields, etc.

You specify what the user gets in your GRANT statement.  See e.g. 
http://dev.mysql.com/doc/refman/4.1/en/grant.html

> No answer here. Just another question or two:
> 
> Is there any way to create user/passwords in batch? 
> 
> Then can priviledges be granted in batch?

Sure; you can pass as many grant statements as you like to mysql via 
standard redirection etc.

--George