Re: Concerned : Developer getting There is no 'root'@'%' registered error message

[Brent Clark]

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>> wrote:
>>
>> Hiya
>>
>> Ill be up front my saying my knowledge of store procedures is limited.
>>
>> A Developer gave me a procedure to load.
>>
>> It starts off with:
>>
>> CREATE DEFINER=`root`@`%` PROCEDURE ....
>>
>>
>> But now, the developer informs me that he gets the following message. 
>> There is no 'root'@'%' registered
>>
>> Googling reveals the following link : 
>> http://forums.mysql.com/read.php?10,237843,238950#msg-238950
>>
>> And that I can run:
>>
>> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH 
>> GRANT OPTION;
>>
>> Im hesitant to do it.
>>
>> My Mysql root acess details are:
>>
>> mysql> select user, host from user WHERE user = 'root';
>> +------+-------------+
>> | user | host        |
>> +------+-------------+
>> | root | 127.0.0.1   |
>> | root | localhost   |
>> +------+-------------+
>>
>> If someone can share their opinion, thoughts or share the same 
>> concerns it would be appreciated.
>>
>> Kind Regards
>> Brent Clark
>>