1) Command line console is always installed with MySQL - telnet to the remote machine and you should be able to run it with no problems. 2) GUI - I reccommend phpmyadmin - get it from the MySQL site. It has a lot of limitations, but the basic functionality is all fine. Tom edwin wrote: > 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"" <[EMAIL PROTECTED]> wrote in message > 9c65b9$nle$[EMAIL PROTECTED]">news:9c65b9$nle$[EMAIL PROTECTED]... > > 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. > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED]
-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
