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

[byron at cc.gatech.edu (Byron A Jeff)]

On Thu, Dec 01, 2005 at 11:57:28AM -0500, Greg Freemyer wrote:
> All,
> 
> I have a MySql server I'm toying with.  I would like to have full
> "root at localhost" privileges from my workstation.
> 
> 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.

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?

I working on a project where I plan to give my students MySQL access
via Phpmyadmin.

Thanks for any assistance.

BAJ