SEO

#1 (**permalink**) 02-28-2008, 07:00 AM

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

#2 (**permalink**) 02-28-2008, 07:00 AM

mdrew@farmingtonfd.com wrote:
> Hey Peoples... How do I get myself of this email list? Thanks
>

It's a very complicated 2 step process:
1) learn to read.
2) follow the directions.

Every email list in the civilized world has instructions on how to
unsubscribe at the bottom or top of EVERY message!

--
Chris W

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode