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