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" <brentgclarkl...@gmail.com
<mailto:brentgclarkl...@gmail.com>> 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
