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 k
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
Googlin
Change the definer to one of your registered root accounts. Root@127 or
root@localhost.
On Aug 17, 2011 8:39 AM, "Brent Clark" 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`
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" wrote:
Hiya
Thank you so much for replying. I really appreciate it.
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' passw
- Original Message -
> From: "Brent Clark"
>
> 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 developer then h
Correct me if I am wrong, but my impression is that usage of
"DEFINER=" 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 Mail
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
Hi all,
No SQLite support?
http://www.sqlite.org/
Seems curious you wouldn't have this yet, especially given its popularity
on
both embedded systems and Android to say the least.
Indeed, no native SQLite support. Lots of other systems are popular and
not supported.
The reason for this is t
10 matches
Mail list logo
