Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2001042

Re: [PHP-WIN] MYSQL Help From: edwin (edwinx <email protected>)
Date: 04/26/01

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 <email protected>> wrote in message
news:9c65b9$nle$1 <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: php-windows-unsubscribe <email protected>
For additional commands, e-mail: php-windows-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>