From: Johnny Withers
Date: August 17 2011 1:54pm
Subject: Re: Concerned : Developer getting There is no 'root'@'%' registered
 error message
List-Archive: http://lists.mysql.com/mysql/225551
Message-Id: <CABEXF2PeABJzurjO4txyYjgLkCr4bRzCXoCy-dJewYnKUAVfRQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001485f774f243595804aab3d5be

--001485f774f243595804aab3d5be
Content-Type: text/plain; charset=ISO-8859-1

It would allow anyone from anywhere to access your server as root with full
access to all databases using the password 'mysql'. Not very secure. I don't
recommend having a root@% defined.

On Aug 17, 2011 8:50 AM, "Brent Clark" <brentgclarklist@stripped> wrote:

Hiya

Thank you so much for replying. I really appreciate it.

I know the answer (well I think I do :) ), but im still going to ask. What
is the risk if do the "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED
BY 'mysql' WITH GRANT OPTION;"
To satisfy the developer.

Thank you again.
Brent



On 17/08/2011 15:42, Johnny Withers wrote:

> >
> >
> > Change the definer to one of your registered root accounts. Root@127 or
> root@localhost.
> >
>
> >> On Aug 17, 2011 8:39 AM, "Brent Clark" <brentgclarklist@stripped<mailto:
> brentgclarklist@stripped...
>

--001485f774f243595804aab3d5be--