you are acting blindly
if would recommend that YOU stay at 5.1 and do not touch things
you do not understand as long we are speaking about production servers
why will you change to innodb?
you know about the differences (fulltext search..)?
you know that for most web-load MyISAM is faster?
you
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
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 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
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
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.
Perhaps he could make the stored procedure functional by creating a user
with the EXECUTE permission (somebody please fell free to correct me if I am
mistaken) if it is to be used to execute a stored procedure. You don't want
someone to attempt using the 'root' username with a typical 'mysql'
- Original Message -
From: Brent Clark brentgclarkl...@gmail.com
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.
That said
Correct me if I am wrong, but my impression is that usage of
DEFINER=user in stored procedures has no impact on runtime and is
actually optional.
(not to be confused with the clause SQL SECURITY INVOKER which is
crucial.)
Note: I use 5.1.32-enterprise-gpl-advanced-log.
David.
--
MySQL General
Apparently Winblows-only.
It sure would be nice if people would note platform requirements in their
announcement, rather than forcing people to dig through their websites for such
info.
I guess I should know better; if it doesn't list platform requirements, the
developer hasn't thought beyond