Hey Peoples... How do I get myself of this email list? Thanks

Original Message:
-----------------
From: Alex Kloss alexkloss@att.net
Date: Wed, 22 Aug 2007 18:16:35 -0400
To: cartoper@gmail.com, mysql@lists.mysql.com
Subject: Re: Access denied for user on Windows Server


Car Toper wrote:
> More info...
>
> I am able to login with the account via phpMyAdmin on the server.
> Also, I am trying to use phpMyAdmin to change the permissions, but I
> cannot figure out the syntax:
>
> GRANT ON ppsntracker.* TO ppsntracker@192.168.0.19 WITH GRANT OPTION;
>
> Cartoper
>
> On 8/21/07, Car Toper <cartoper@gmail.com> wrote:
>
>> I have a MySql server running on a Windows box that I cannot connect
>> to from another machine. I first checked to make sure the user has
>> the correct permissions, which the user does, it has the %. I did
>> read something that gave me the impression the user needs to have a
>> tranditional windows account on the machine, so I created one. Still
>> nothing. Is there anything special I need to do to allow access to
>> MySql when the database is running on a different machine?
>>
>>
>
>
If you're trying to create a superuser on the server, you would use

GRANT ALL PRIVILEGES ON ppsntracker.* TO ppsntracker@192.168.0.19 WITH
GRANT OPTION;

Although I wouldn't recommend this for security purposes; it's a much
more secure idea to selectively grant the
privileges as necessary to the user and assign a password, such as

GRANT SELECT,INSERT,DELETE ON ppsntracker.* TO ppsntracker@192.168.0.19
IDENTIFIED BY 'password';

And so forth.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...rmingtonfd.com



--------------------------------------------------------------------
myhosting.com - Premium Microsoft® Windows® and Linux web and application
hosting - http://link.myhosting.com/myhosting