Hey Peoples... How do I get myself of this email list? Thanks
Original Message:
-----------------
From: Alex Kloss alexkloss@stripped
Date: Wed, 22 Aug 2007 18:16:35 -0400
To: cartoper@stripped, mysql@stripped
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@stripped WITH GRANT OPTION;
>
> Cartoper
>
> On 8/21/07, Car Toper <cartoper@stripped> 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@stripped 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@stripped
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=1
--------------------------------------------------------------------
myhosting.com - Premium Microsoft® Windows® and Linux web and application
hosting - http://link.myhosting.com/myhosting
