Re: MYSQL Help

hi, thanks!! btw, do you know any good commandline or gui clients for Mysql? i want to administer the DB remotely... thanks ed ""Johannes Janson"" <johannes.janson@gmx.de> wrote in message news:9c65b9$nle$1@toye.p.sourceforge.net... > hi, > > the info in the manual about the command line in mysql apply also > for win2k. Assuming you have root access go to the mysql prompt > and type this: > GRANT select, insert, update, delete, WhatPrivYouWant ON YourDB.* TO > username > IDENTIFIED BY 'YourPassword'; > > This creates a user "username" with pasword "YourPassword" who has the > specified priviledges > on all tables in YourDB.