Re: MYSQL Help
| From: | Tom Mathews | Date: | Thu, 26 Apr 2001 08:56:13 +0000 |
| Subject: | Re: MYSQL Help | ||
| References: | 1 2 3 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-7056@lists.php.net to get a copy of this message | ||
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"" <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.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net