List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:August 17 2011 1:54pm
Subject:Re: Concerned : Developer getting There is no 'root'@'%' registered
error message
View as plain text  
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...
>

Thread
Concerned : Developer getting There is no 'root'@'%' registered errormessageBrent Clark17 Aug
Re: Concerned : Developer getting There is no 'root'@'%' registerederror messageJohnny Withers17 Aug
  • Re: Concerned : Developer getting There is no 'root'@'%' registerederror messageBrent Clark17 Aug
    • Re: Concerned : Developer getting There is no 'root'@'%' registered error messageJohan De Meersman17 Aug
      • RE: Concerned : Developer getting There is no 'root'@'%' registered error messageDavid Lerer17 Aug
        • Re: Concerned : Developer getting There is no 'root'@'%' registered error messageJohan De Meersman18 Aug
          • RE: Concerned : Developer getting There is no 'root'@'%' registered error messageDavid Lerer18 Aug
            • Re: Concerned : Developer getting There is no 'root'@'%' registered error messageJohan De Meersman18 Aug
Re: Concerned : Developer getting There is no 'root'@'%' registerederror messageJohnny Withers17 Aug
  • Re: Concerned : Developer getting There is no 'root'@'%' registerederror messageJon Siebert17 Aug